I have data, for which I am creating a macro to create a pivot table and charts. I am trying to display performance from the data by creating pivot charts on different time periods.

I have the pivot table and I create a chart to show yearly performance. Then I change values in the pivot table to create a monthy performance chart and then a weekly performance chart.I need the macro to create the pivot table and 3 radio buttons.

After which, I will click on the radio button, to display different performance charts based on changing pivot table values.

I was able to record macro to create PT and radio buttons. But is it possible to retain functionality of radio button, since everytime it is created new by running the macro.