Filter a field in a chart

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.

1. Click the arrow for the field that contains the items of data that you want to filter.
2. 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.

1. Select the series or point that has the values you want to filter.
2. On the toolbar, click Show Top/Bottom Items .
3. Point to Show Only the Top or Show Only the Bottom, and then click the number or percentage you want.

Note  When items in a field are hidden by an autofilter, the arrow in the field label is blue.