Macro to create pivot table/pivot chart

[Karina]

Hello,

I would like to have a macro that creates a pivot table and/or a pivot chart that show average percentage of expenses for each month so that pivot tables/graphs could be automatically created for data of each department and branch. The example of how a pivot table/chart would look is shown in the attachment.

I don't think I could just record a macro because the number of rows would be different in each situation, so the range of the initial table would be always different.

Thank you so much for your help.

[arlu1201]

This code should help you out. Its dynamic enough to take as many rows as there are in the "Data" tab. When you want to run this macro, delete the old pivot that you have and run the code. It also gives you a pivot chart.

Please Login or Register  to view this content.

[Karina]

Thank you very much, Arlu. It works really well.