Excel Macro to Create Automatic PIVOT Charts

$10-30 USD

Completed

Posted

about 5 years ago

$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.

Data Processing

Excel

Visual Basic

Visual Basic for Apps

Project ID: 18956268

About the project

9 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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

4.9

(349 reviews)

6.9

9 freelancers are bidding on average $39 USD 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 day

5.0

(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

4.9

(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, and Data Entry as well. I’m honest, creative and a unique person to carry out your tasks given to me. Leaving your project on our hand is privileged; we'll make sure that the project is done in a perfect way and do our best until you were satisfied. I would love to discuss this project with you and meet your exact requirements. I am confident I can provide you with top-notch materials that will fit your needs. I'm proud of my work on being professional, of the highest quality and always delivered on time.

$25 USD in 1 day

4.9

(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

4.9

(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

5.0

(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 like the work then only pay. Please give me a chance. Please

$20 USD in 0 day

5.0

(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 day