Suoritettu

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.

Taidot: tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 4 arvostelua ) Clarion, United States

Projektin tunnus: #18956268

Myönnetty käyttäjälle:

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 3 päivässä
(298 Arvostelua)
6.7

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 0 päivässä
(834 arvostelua)
7.9
bouslimi1979

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

$100 USD 1 päivässä
(283 arvostelua)
7.6
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 Lisää

$25 USD 1 päivässä
(10 arvostelua)
4.4
haleem0786

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 1 päivässä
(16 arvostelua)
3.6
dungchan44

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing and analysis by drawing chart using Excel Formula and VBA. I have finished a lot of projects like this. I can s Lisää

$25 USD 1 päivässä
(15 arvostelua)
3.7
gsanggara

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

$50 USD 1 päivässä
(20 arvostelua)
3.8
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 1 päivässä
(10 arvostelua)
3.3
redmapple3

hi dear. your job is interesting for me. please contact me then we can discuss more detail via chat. thanks. best regards.

$25 USD 1 päivässä
(1 arvostelu)
1.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 Lisää

$20 USD 0 päivässä
(0 arvostelua)
0.0
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 0 päivässä
(0 arvostelua)
0.0