I am trying to create a macro that allows me to create a pivot table and the corresponding pivot chart.
For example, within an organization, I have business units and for each business unit, there are regions.
For each region, there is a % revenue of total in the pivot table.
I need to create donut charts for the regional breakup of revenue for each of the 11 business units.
I am still a beginner with respect to Macros, therefore, I recorded the macro.
I have 2 questions:
a. How do I create a repetitive macro that creates these 11 donut charts for me?
b. When I run the macro, it gives me a Runtime Error '5' and it is not because of the folder name. How do I get rid of this?
Thanks in advance