Create Excel Workbook with specific outcome (Pivot), done by a c# tool
- or -
Post a project like this$$
- Posted:
- Proposals: 4
- Remote
- #2227792
- Expired
Description
Experience Level: Intermediate
I have a workbook in excel, which has 20 columns (date, string, float) and lets say 100 rows.
What shall the c# tool do?:
New Sheet: I want to create a pivot table with it, specific look, colors, order.
New Sheet 2: also pivot, create an overview like attached pic. The most important thing about it, that we have slicers in it. Slicers are buttons, that when I click, the view of the Column Chart changes, because the data in the background is something else. I think you know what I mean.
What I want from you:
I want to have basic coding to see, how can I do this.
1) How can I create pivot table with specific look, colors, order.
2) How can I create pivot pie charts
3) How can I create 2D Column Chart
4) How can I make the 2D Column Chart interactiv with slicers
5) How can I place the views exactly where I want them on the worksheet (like left upper corner of the view beginns x coordinate = 120, y = 200) and how big they shall be (width = 520, heigth = 260)
I would give you example Data and you start Coding. Make a C# UI (very very easy) and code for the 5 cases. Is that possible for you? I need to have an idea how to solve those problems.
Many thanks in advance!
Oliver
What shall the c# tool do?:
New Sheet: I want to create a pivot table with it, specific look, colors, order.
New Sheet 2: also pivot, create an overview like attached pic. The most important thing about it, that we have slicers in it. Slicers are buttons, that when I click, the view of the Column Chart changes, because the data in the background is something else. I think you know what I mean.
What I want from you:
I want to have basic coding to see, how can I do this.
1) How can I create pivot table with specific look, colors, order.
2) How can I create pivot pie charts
3) How can I create 2D Column Chart
4) How can I make the 2D Column Chart interactiv with slicers
5) How can I place the views exactly where I want them on the worksheet (like left upper corner of the view beginns x coordinate = 120, y = 200) and how big they shall be (width = 520, heigth = 260)
I would give you example Data and you start Coding. Make a C# UI (very very easy) and code for the 5 cases. Is that possible for you? I need to have an idea how to solve those problems.
Many thanks in advance!
Oliver
Oliver G.
100% (3)Projects Completed
3
Freelancers worked with
1
Projects awarded
40%
Last project
30 Dec 2018
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies