Excel Macro to Create Automatic PIVOT Charts

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.

Skills: Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: macro to create pivot table with dynamic range, vba create pivot table on new sheet, macro to change pivot table filter, pivot table macro code, excel vba create pivot table in existing sheet, vba pivot table filter, excel vba pivot table add data fields, excel macro create pivot table, excel macro create directory mkdir, excel macro create permutations, excel macro create txt file, excel macro create shape, excel macro create unique file worksheet worksheet name, excel macro create xsd, excel macro create files, excel macro references automatic check, excel macro create file local directory, excel macro create folder, excel macro create dat file, excel macro create number xml files

About the Employer:
( 9 reviews ) Clarion, United States

Project ID: #18956268

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

$30 USD in 3 days
(349 Reviews)

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

$35 USD in 0 days
(883 Reviews)

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)

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)

i can do this. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox [login to view URL]

$50 USD in 1 day
(24 Reviews)

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)

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)

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)

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)