Edit Graph 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:
Edit Graph dialog: Titles, Totals, and Series page

For more information, see:

"About components of a Discoverer graph"

Show title

Use this check box to display or hide the graph title defined in the field 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 (for example, 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 "Edit Graph 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 options to specify what data to include on the graph.

  • Data only

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

  • Totals only

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

  • Both data and totals

    Use this option 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 options to specify which items to put on the X-axis of a graph.

  • Columns

    Use this option 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 option 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 options 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 option 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 option, use the Pie Chart Options button to display the "Edit Graph dialog: Pie Chart Options tab (column)", which enables you to change which item you use as the graph series.

  • Rows

    Use this option 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 option, use the Pie Chart Options button to display the "Edit Graph 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 "Edit Graph dialog: Pie Chart Options tab (column)" or "Edit Graph dialog: Pie Chart Options tab (row)", which enable you to change which item you use as the graph series.