Excel Macro to Create Automatic PIVOT Charts

Selesai Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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.

Pemrosesan Data Excel Visual Basic Visual Basic untuk Aplikasi

ID Proyek: #18956268

Tentang proyek

9 proposal Proyek online Aktif 5 tahun yang lalu

Diberikan kepada:

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 dalam 3 hari
(349 Ulasan)
6.9

9 freelancer rata-rata menawar $39 untuk pekerjaan ini

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 dalam 0 hari
(883 Ulasan)
8.0
bouslimi1979

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

$100 USD dalam 1 hari
(295 Ulasan)
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 Lebih banyak

$25 USD dalam 1 hari
(17 Ulasan)
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 dalam 1 hari
(26 Ulasan)
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 dalam 1 hari
(10 Ulasan)
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 Lebih banyak

$20 USD dalam 0 hari
(9 Ulasan)
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 dalam 0 hari
(0 Ulasan)
0.0