Help with pivot table macro

ejima · #1 02-02-2012, 02:54 AM

Hello All,
I created a pivot table from the data on sheet titled RawData however, there are some modifications i will like made on the pivot table:
Please find attached the sample data for further clarifications.
1) The sheet titled rawdata contains the data from which pivot chart is created.

2) The sheet titled "Pivot Chart gotten from macro" is the pivot chart gotten after the macro runs.
3) the sheet titled "expected outcome" is the pivot chart done without using a macro, this is the outline which we want to get when we run the macro for the pivot chart.

I need assistance with modifying the macro foso that i can get the pivot chart displayed in the format represented in the sheet "expected outcome" and also ensuring user input is requested for the pivot table's sheet i.e the sheet is named after whatever user input is fed before the pivot table is created.

The macro is attached in text format and the excel document is in the zipped folder.
Thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA: Recording a macro to insert a PIVOT table	e093223	Excel Programming	0	10-09-2011 01:55 AM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM
pivot table design 2	dmonroe	Excel	2	11-15-2010 09:15 AM
Pivot Table Refresh	tpcervelo	Excel	0	09-14-2010 06:54 AM
Pivot Table's fields	janis129	Excel	7	03-02-2010 03:16 PM