Using the User Charting Options

Use the User Charting Options dialog box to change the chart layout, chart axis, filters, and so on. In the Advanced Options section, you can specify the chart default dimensions, exploded pie chart, Y-axis precision, and legend positioning.

Navigation

Open the User Charting Options dialog box by selecting the Chart Options option from the Option Menu icon on the Pivot Grid Viewer page.

Image: User Charting Options dialog box

This example illustrates the fields and controls in the User Charting Options dialog box.

User Charting Options page

Note: The X Axis, Y-Axis Series, Overlay Field, and Chart Filters fields in the User Charting Options dialog box are not editable if the display option is Pivot Grid and Chart.

Field or Control

Definition
Title

Enter the title of the pivot grid.
Subtitle

Enter the subtitle if required. It displays under the title with smaller font size.
Footer

Enter additional information to display as footer text.
Type

Select the display type of the chart . See Chart Options.

Note: 3-D charts are not supported as a chart type.
X-Axis

Select to change the X-Axis. You can change the X-axis from the User Charting Options, if you decide to use another field as x-axis.
X-Axis Label

Enter or modify the X-Axis label.
Y-Axis

Select to change the Y-Axis. You can change the X-axis from the User Charting Options, if you decide to use another field as y-axis.
Y-Axis Label

Enter or modify the Y-Axis label.
Series

Select the x-axis field to define as series.
Overlay Field

Select the Y-axis field to define as an overlay.
Chart Filters

Add or delete filters displayed on the chart view.
Advanced Options

Define display options for the chart, including chart legend, and height and width of the chart.