Remove filters to display all data in a chart

Office Web Component Chart

Show All

Remove filters to display all data in a chart

When items in a field are hidden by filtering a field, the arrow Field arrow in the field label is blue.

  1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
  2. Do one of the following:

    Remove all filters

    Remove an autofilter from a field

    Remove a conditional filter

Notes
  • If you don't want to retain your filters, make sure the AutoFilter button is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.
  • You can prevent users from removing filters in the browser by clearing the Allow pivot filtering check box on the Show/Hide tab of the Commands and Options dialog box.