question

TracyM-9789 avatar image
0 Votes"
TracyM-9789 asked TracyMyles commented

PivotChart / PivotTable Data Source range

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!

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered TracyMyles commented

@TracyM-9789

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you!

0 Votes 0 ·