筛选数据透视图

筛选器用于从数据透视图移除不想要的数据。您可以在数据透视图中或相应的数据透视表中使用筛选器，因为最终生成的图表是完全一样的。

「数据透视图」字段按钮

Pivot chart buttons are unique to pivot charts, normal charts don't have them. The buttons shows the layout of the pivot table, which are the pivot table fields. If present, filters are displayed in the top. Row fields are displayed on the bottom of the chart next to each other and the legend shows the buttons from column fields stacked.

按钮附有弹出动作。如果应用了筛选，箭头会变蓝 (与数据透视表类似)，因此很容易看出字段是否应用了筛选。

Existing filters shows what is filtered: when nothing is filtered "- all -" is shown, when some data is filtered, then "- multiple -" is shown and when only one value is not filtered, the value is shown.