Macro for filter in a pivot table

Hi Community,

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

Ankit