To Chart dialog

This dialog appears when you right-click a crosstab and then select To Chart on the shortcut menu or click Menu > Edit > To Chart. It allows you to specify settings for converting a crosstab into a chart. See the dialog.

Title

Specifies a title for the chart.

Specifies the font, font style, size, align, font color and background color properties for the title.

Resources

Displays all the view elements used in the crosstab.

Adds the selected group or aggregation object to be displayed in the chart.

Category

Lists the group object that will be displayed on the category axis of the chart.

Series

Lists the group object that will be displayed on the series axis of the chart.

Show Values

Specifies the types for chart and sets the values for the Primary Axis or Secondary Axis separately.

• Primary Axis
  Adds a chart type to the primary axis.
• Secondary Axis
  Adds a chart type to the secondary axis.
• X Axis
  Lists the value you want to show on the X axis of the bubble chart.
• Y Axis
  Lists the value you want to show on the Y axis of the bubble chart.
• Radius
  Lists the value you want to show as the bubble radius.

Secondary Axis

Specifies whether to show the secondary axis in the chart.

Opens the Category Options dialog or Series Options dialog to define the sort order of the category or series values and specify the number of the category or series values that will be displayed in the chart.

Adds a combo chart to the Primary Axis or Secondary Axis.

Moves the selected view element one level up.

Moves the selected view element one level down.

Adds a new pair of Y Axis and Radius for the bubble chart.

Removes the selected view element.

OK

Applies the settings and closes the dialog.

Cancel

Cancels the settings and closes the dialog.

Help

Displays this help document.