Filter a field in a chart

1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. Click the arrow for the field that contains the items of data that you want to filter.
3. 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. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. Select the field, series, or point that has the values you want to filter.
3. On the toolbar, click Commands and Options , and then click the Filter and Group tab.
4. In the Display the box, click Top or Bottom.
5. Set Items to a number in the list, or type the value you want.
6. To show n number of items, clear the % check box. To show n% of items, select the % check box.
7. Set Based on to a value in the list.