Filter a field in a chart
Filter a field in the category, series, or filter area (autofiltering)
If the filter area does not have a field, you can either add a new field or move a field from another area to the filter area.
- In the design window, make sure the chart is activated. For instructions, see Help for your design program.
- Click the arrow for the field that contains the items of data that you want to filter.
- Select the check boxes for the items you want to display, and clear the check boxes for the items you want to hide.
Notes
- To display or hide all of the data for a field, select or clear the (All) check box. A shaded check box indicates that some items are hidden.
- When placed in the category, series, or filter area, a field always supports multiple selection. A field in the filter area can support either single or multiple selection.
Filter a series or point for the top or bottom n values, or for a percentage (conditional filtering)
- In the design window, make sure the chart is activated. For instructions, see Help for your design program.
- Select the field, series, or point that has the values you want to filter.
- On the toolbar, click Commands and Options , and then click the Filter and Group tab.
- In the Display the box, click Top or Bottom.
- Set Items to a number in the list, or type the value you want.
- To show n number of items, clear the % check box. To show n% of items, select the % check box.
- Set Based on to a value in the list.