Graph Wizard: Titles, Totals, and Series dialog

Use this dialog to configure a graph.

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 field below.

Title field

Use this field to enter a title for the graph. By default, the title is displayed above the graph. Once defined, you can drag and drop the title to a new location.

Insert

Use this button to add pre-defined graph details to your graph title. These include the worksheet name, workbook name, current date, and current time. These values are updated automatically when you look at a graph.

Title Font

Use this button to display the Title Font dialog. Here, you can change the default font, font style, font size, font color, and alignment style (see "Graph Wizard: Font dialog").

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 graph the worksheet data details, when you want a full report.

• Totals only

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

• Both Data and totals

  Use this radio button to graph 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. That is, 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. That is, 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 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 graph series, see "Notes about creating pie charts").

• Columns

  Use this radio button to graph the values in the first column on the X-axis. One of the other items is displayed as a series on the graph. In other words, its values are represented on the pie chart as slices of the pie. Use the Pie Chart Options button to display the Pie Chart Options dialog, where you choose which of the other items to use as the graph series.

• Rows

  Use this radio button to graph the values in the first column the X-axis. One of the items in the first column is displayed as a series on the graph. In other words, its values are represented on the pie chart as slices of the pie. Use the Pie Chart Options button to display the Pie Chart Options dialog, where you choose which of the other items to use as the graph series.

Pie Chart Options

Use this button to display the Pie Chart Option dialog (when you have selected the Pie Chart graph style in the previous dialog). Here, you select which column or row you want to display on your graph.

Graph Details Pane

This area displays a summary of the graph configuration that you have specified.