Allow multiple or single selection for a field in the filter area

Office Web Components

Allow multiple or single selection for a field in the filter area

You can specify whether a field will allow single or multiple selection when in the filter area. In single-selection mode, selecting an item automatically clears the previous selection. In multiple-selection mode, when you select an item, previously selected items remain selected.

  1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
  2. Select the field for which you want to change the setting. The field should not yet be in the filter area, but in one of the other areas in the chart, such as a series or category area.
  3. On the toolbar, click Commands and Options Button image, and then click the Filter and Group tab.
  4. Select or clear the Allow selecting multiple items when in filter area check box.

    When the field is moved to the filter area, it will reflect the new setting.

Notes

  • By default, multiple selection is enabled.
  • This setting applies only when the field is in the filter area. If you move the field to a category or series area, the field will always support multiple selection.