PivotChart / PivotTable Data Source range

Question

Hello,

I have a PivotChart whose data source is the entire worksheet, however I want to change the data source to exclude any filtered out columns/rows. Is there a function to do so, such as a true value or filtered value for the chart data source?

thank you!

Answer 1

@Tracy M

I think you need to change the data source, choose the correct data range for your pivot table.

Or you could try to split the data range, then use the PivotTable and PivotChart Wizard to consolidate multiple ranges.
For detailed information, please refer to "Consolidate multiple worksheets into one PivotTable".

Any misunderstanding, please let me know.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.