Filter pivot-chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2348448%22%20slang%3D%22en-US%22%3EFilter%20pivot-chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20pivot%20table%20and%20a%20chart%20linked%20to%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20I%20sort%20any%20column%20in%20the%20pivot%20table%2C%20the%20chart%20reflects%20the%20sort.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EBut%2C%20filtering%20a%20column%20that%20contains%20prices%20so%20that%20only%20prices%20above%201%2C000%24%20are%20displayed%2C%20for%20example%2C%20does%20not%20affect%20the%20chart%20at%20all.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20question%20is%3A%20how%20do%20I%20create%20an%20ADVANCED%20FILTER%20for%20pivot-chart%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20using%20Win%2010%20with%20Office%202019%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20for%20helping%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348448%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

3 Replies

@Rafaels200 

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.

I can filter by using slicers, but I don't want to display all data. I have 100 silces, and I want to display only the silces that has a value wich is "grater than.." somthing - this is something very simple in a pivot table, but how do I reflect it in the chart?

@Rafaels200 

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.