I'm building a Dashboard and I want to use a single chart while creating a macro that will switch pivot table while using the same chart. Instead of having 2 separate charts, one for sum and one for average, I would like to have one single chart on my Dashboard and include a button that will switch from sum to average to display the pivot table info on the chart. I already know how to create a button and assign a macro to it with the developer tab.
How do i create a macro that will switch from Pivot table 1 to Pivot table 2 using the same chart ?
If there is any other solution let me know.
Thank you.
Evendis.
How do i create a macro that will switch from Pivot table 1 to Pivot table 2 using the same chart ?
If there is any other solution let me know.
Thank you.
Evendis.