How to switch the source “table” or “query” for the “Pivot Chart”?

[jamal numan]

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

[June7]

This is a form set to PivotChart view? The data sources all have the same field names?

Want to provide db for analysis? Follow instructions at bottom of my post.

[jamal numan]

This is a form set to PivotChart view? The data sources all have the same field names?

Want to provide db for analysis? Follow instructions at bottom of my post.

thanks for the answer.

best

Jamal