Kindly assist with pivot chart macro

[ejima]

Hello All,

I created a pivot table (using macro) 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.

[Bob Phillips]

Please Login or Register  to view this content.

[ejima]

Hello Bob,

Thanks for your response.

However, the macro above only created a new worksheet, no pivot table was created

It gave error " run time error 5, invalid procedure call or argument"

Kindly assist.

Thank you.

[Bob Phillips]

ARe you on Excel 2007? If so try changing TableVersion14 to TableVersion12.