Excel Macro to Create Automatic PIVOT Charts

Completed Posted 5 years ago Paid on delivery
Completed 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.

Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #18956268

About the project

9 proposals Remote project Active 5 years ago

Awarded to:

TonmoyRoy111

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

$30 USD in 3 days
(349 Reviews)
6.9

9 freelancers are bidding on average $39 for this job

cgullapalli

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

$35 USD in 0 days
(883 Reviews)
8.0
bouslimi1979

The macro will be done in the next 6 hours. I m ready to start, all is clear. Thanks ***********************************************************************************

$100 USD in 1 day
(295 Reviews)
7.7
olaideejiwole

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

$25 USD in 1 day
(17 Reviews)
5.0
gsanggara

I am clear on the instruction, ready to work on it and able to complete within next 6 hours. regards_gsanggara

$50 USD in 1 day
(26 Reviews)
4.2
hemsingh1

Excel & VBA expert with over 6 years of experience. I can help to create a macro as specified & deliver as expected. Thanks

$35 USD in 1 day
(10 Reviews)
3.4
IbexEnterprises

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

$20 USD in 0 days
(9 Reviews)
2.4
mus1234

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

$10 USD in 0 days
(0 Reviews)
0.0