Graph Wizard dialog: Y2-Axis tab

Use this dialog to configure the Y2-axis (i.e. the secondary vertical axis) of a graph. For example, you might have sales plotted on the Y1-axis on the scale 0 to 100,000 and

want to specify a title for the Y2-axis on a dual-Y Bar chart.

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

For more information, see:

"About using graphs in Discoverer"

"About components of a Discoverer graph"

"How to edit a graph"

Show Y2-Axis title

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

Insert

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

Y2-axis Title Font

Use this button to display the "Graph Wizard dialog: Font dialog tab", which enables you to change the font style of the Y2-axis label.

Select options for line on the Y2-axis

• Line thickness

  Use this drop down list to change the weight of the Y2-axis line.

• Line color

  Use this color pane to change the color of the Y2-axis line.

Set the scale you would like to use on this axis

Use the following fields to change the scale of the X-axis.

• Minimum

  Use this field to change the default lower axis range. Select the Set automatically check box if you want Discoverer to select the best range for you.

• Maximum

  Use this field to change the default higher axis range. Select the Set automatically check box if you want Discoverer to select the best range for you.

• Increment

  Use this field to change the default incremental axis range, or the granularity of the graph. Select the Set automatically check box if you want Discoverer to select the best range for you.

• Base line value

  Use this field to specify a starting value for the Y2-axis. For example, you might have a monthly sales target of 10,000 units and you want to emphasis how total sales for each month relate to the 10,000 target. In other words, on a vertical Bar graph you want to:

  • display monthly sales totals greater than 10,000 above the base line

  • display monthly sales totals less than 10,000 below the base line.

  To achieve this graph layout you set the base line value to 10,000.

  Note: The Base line value field is grayed out on the following types of graph:

  • Bubble

  • Scatter

  • Stock

  • Polar

  • stacked graphs (e.g. Bar graphs of sub-type Dual-Y Stacked)

  • percent graphs (e.g. Bar graph of sub-type Percent)

  Note: If you are familiar with graphs in Microsoft Excel, changing the base line value is similar to setting the Category value in Microsoft Excel graphs.

Logarithmic scale

Use this check box to change the default linear scale of the X-axis to a logarithmic scale. When you select this check box, the adjacent Base drop down list becomes active, which enables you to change the default logarithmic base value.

You might use a logarithmic scale when you have numeric data that is widely spaced and you want to maintain the visibility of the smaller values. For example, if you had data ranging in value from 10 to 100,000 and you use the default linear scale, smaller values might not register on the graph. If you changed to a logarithmic scale of base 10, the smaller values would register on the graph.

Note: The e value in the Base drop down list is equal to 2.71 (sometimes referred to as a natural logarithm).

Y2-axis Label Font

Use this button to display the "Graph Wizard dialog: Font dialog tab", which enables you to change the font style of the Y2-axis label.

Reference Lines

Use this button to display the Reference Lines dialog, which enables you to define up to three lines on a graph to emphasize particular data values on a graph. For example, you might add a reference line show the target sales value, to emphasize which regions achieved a target. For an example of a reference line on a graph, see "About components of a Discoverer graph".

Notes

• Depending on which type of graph you are creating, the fields you can use might change as follows:
  • Minimum, Maximum, Increment, and Logarithmic scale fields are grayed out on percent graph types (e.g. Bar graph of sub-type Percent)

  • Minimum, Maximum, and Logarithmic scale fields are grayed out on Pareto graphs