Microsoft Office Tutorials and References
In Depth Information
Limiting the data shown in a chart can help you and your
colleagues focus on the facts that are most relevant to your
situation. Excel 2013 gives you the ability to select which values
appear in your chart by using the Chart Filters button, which
the program displays next to the chart. Selecting or clearing the
check box next to a category (horizontal) axis value displays or
hides that value in the chart. When a filter is applied, the Select
All check box contains a gray square to indicate that some
values are hidden.
Filter a chart
1 Click the chart that you want to filter.
2 Click the Chart Filters button.
3 Select or clear the check boxes next to items that you want to
display or hide.
4 Click Apply.