Answer

The Chart Filters button is in the upper-right corner of a selected chart. It appears as a funnel icon that controls visible data points and series.

How to locate the Chart Filters button in Excel

1. Click the chart.

2. Look at the upper-right corner of the chart boundary.

3. Identify the funnel-shaped icon labeled Chart Filters.

4. Select the icon to open the filtering pane for data series and categories.

Where the Chart Filters button appears on Windows vs. Mac

Windows shows the Chart Filters button directly on the chart once the chart is selected.
Mac shows the Chart Filters button only when the chart uses a supported chart type and the chart is selected.

Chart types that display the Chart Filters button

The button appears on column charts, bar charts, line charts, area charts, and similar standard chart types.
The button does not appear on PivotCharts because PivotCharts use dedicated field buttons for data control.

What the Chart Filters button controls

The button controls data visibility for charted values and labels.
The button limits the display to selected categories and series without changing the source dataset.

Why the Chart Filters button may not appear

The button disappears when the chart is not selected.
The button disappears when the workbook uses compatibility mode.
The button disappears when the chart uses a non-supported type, such as 3-D surface charts or Treemaps.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report