Excel Macro to Create Automatic PIVOT Charts
$10-30 USD
Paid on delivery
I've a dataset in Excel File, from which I want to create a Pivot Chart. I want to get a Macro Enabled button, clicking on it asks to upload Excel Dataset, and looks at the data, manipulates it a little bit, and creates Pivot Charts from it in a new tab.
Here's what I want to do.
Column 1 has a data like "190123000000" which translates to "YYMMDDHHMMSS" giving it year-month-date-hour-minute-second format. Column 14 has a data "190123072000" in the similar format as above. Column 16, 17, 18, 19 has numerical data like "0", "1", "4", "9".
What I want Macro to do is this:
1. Get column 14 data, and extract Hour out of it. (Exa: 190123072000, get 07)
2. Sum Column 16, 17, 18, 19 (Exa: 0+1+4+9 = 14)
3. Create a Pivot Chart which looks like Image 1. Find it attached.
4. Get column 1 data, and using a sum of column 16, 17, 18, 19 create a graph like Image 2. Find it attached.
Dataset is attached. Images (of Graphs) are attached. Need to get it done within next 6 hours.
Project ID: #18956268
About the project
Awarded to:
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
9 freelancers are bidding on average $39 for this job
HI, I am good at Excel and VBA. I will automate the data and produce the required pivot charts. looking forward to discuss and work on the project. I can meet the deadline provided. -Chandra
The macro will be done in the next 6 hours. I m ready to start, all is clear. Thanks ***********************************************************************************
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language More
I am clear on the instruction, ready to work on it and able to complete within next 6 hours. regards_gsanggara
Excel & VBA expert with over 6 years of experience. I can help to create a macro as specified & deliver as expected. Thanks
I can do this project in 1 hr only. I am new freelancer here but having a very rich experience in MS Excel. Please give me a chance to work for you. Don't pay me anything in advance, firstly I i do your work and if you More
Hello I am a computer engineer and I am new on siteweb can help you with vba with a comprtitive offer Do not hesitate to contact me if you are not satisfied, I'll kick you back