Hello experts,
I have a pivot table and a chart linked to it.
If I sort any column in the pivot table, the chart reflects the sort.
But, filtering a column that contains prices so that only prices above 1,000$ are displayed, for example, does not affect the chart at all.
My question is: how do I create an ADVANCED FILTER for pivot-chart
I'm using Win 10 with Office 2019
Thanks for helping
Filtering a column does not remove the data from the column - use a page filter instead, and the data will be removed from the table when you update the page filter. It may also be easier to add a column to your data table that returns a True/False value keyed to a cell that you enter a value, like =B2>=$I$2 Enter 1000 in I2, and use that column as your page filter, to show only True values.
Bernie Deitrick
Excel MVP 2000-2010
Filter is available via the Axis Field Buttons:
Axis Field Buttons.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks