Graph Wizard dialog: Titles, Totals, and Series tab

Use this dialog to configure a graph. For example, you might want to change a graph title or graph title font.

Note: The fields that you use to specify a graph depend on the graph type selected.

This dialog is also displayed as:

Title dialog

For more information, see:

"More about worksheets and graphs"

"About components of a Discoverer graph"

"How to edit a graph"

Show title

Use this check box to display or hide the graph title defined in the box below. By default, the title is displayed above the graph.

Insert

Use this button to add report information derived from dynamic values to the graph title (e.g. workbook name, current date, current time). These dynamic values are updated automatically when you display, print, or export a graph.

Title Font

Use this button to display the "Graph Wizard dialog: Font dialog tab", which enables you to change the font style of the graph title.

What would you like to display in your graph?

Use these radio buttons to specify what data to include on the graph.

• Data only

  Use this radio button to display all worksheet data, when you want a full report.

• Totals only

  Use this radio button to display worksheet totals, when you want a summary only.

• Both Data and totals

  Use this radio button to display the worksheet data and totals, where you want a full report with totals.

Show null values as zero

Use this check box to display null values (or empty data values) as zeros.

Graph series by (not Pie Chart style)

Use these radio buttons to specify which items to put on the X-axis of a graph.

• Columns

  Use this radio button to put the first item on the worksheet on the X-axis (horizontal axis). The other items are series on the graph. In other words, their values are represented on the graph on the Y-axis (vertical axis).

• Rows

  Use this radio button to represent the first item as a series on the graph. In other words, its value is represented on the graph on the Y-axis (vertical axis). The other values are placed on the X-axis (horizontal axis).

Graph series by (Pie Chart graph style)

Use these radio buttons to specify which items to put on the X-axis of a Pie Chart (for more information about how to plot rows and columns in a Pie Chart, see "Notes about creating pie graphs").

• Columns

  Use this radio button to plot the values in the first column on the X-axis. In other words, the column's values are represented on the pie chart as slices of the pie. When you select this radio button, use the Pie Chart Options button to display the "Graph Wizard dialog: Pie Chart Options tab (column)", which enables you to change which item you use as the graph series.

• Rows

  Use this radio button to plot the values in the first row on the X-axis. In other words, the row's values are represented on the pie chart as slices of the pie. When you select this radio button, use the Pie Chart Options button to display the "Graph Wizard dialog: Pie Chart Options tab (row)", which enables you to change which item you use as the graph series.

Pie Chart Options

Use this button to display the "Graph Wizard dialog: Pie Chart Options tab (column)" or "Graph Wizard dialog: Pie Chart Options tab (row)", which enable you to change which item you use as the graph series.