May 12 2021 06:07 AM
Hello,
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
May 12 2021 06:34 AM
Filtering the source range will not affect the pivot table, nor the pivot chart.
But filtering data in the pivot chart itself will affect the pivot chart too.
You can use the filter dropdown arrow(s) in the pivot table or pivot chart for this, or add slicers.
May 12 2021 06:46 AM
May 12 2021 07:02 AM
Do you want to filter on a value field? If so, click on the filter/sort dropdown in the row labels header of the pivot table and click on Value Filters. You can select options such as 'Greater than...' from the submenu.