The chart dimension filter appears when a dimension is set as a filter in the Axes Placement tab in the Chart Types and Configuration dialog box. Use this filter to change the view of the data on-the-fly.
The available chart dimension filters appear in a drop down list. For example, if Year is a dimension filter, the chart can present data for a given year or for any of its quarters.
To change the dimension member on which the data is filtered:
![]() |
You can also access the dialog from the chart's right-click menu. Select Chart Types.... from the right-click menu to bring up the dialog and then click the Axes Placement tab. |
When you click the Apply button the changes are implemented but the dialog box remains open.