How to switch the source “table” or “query” for the “Pivot Chart”?
I wanted to change the source “table” or “query” for the “Pivot Chart” but sounds not to work with me. The reason I wanted to do that is I need to apply particular settings (appearance) for one chart and then just changing the source to have the same style for all my charts.
How can I just change the source “table” or “query” for the “Pivot Chart”?
Thank you for the help,
Best
Jamal