Help Topics

Using and Splitting the Y Axis


You can split the Y axis using bi-polar or dual axis chart types. when the Measures dimension (if available in the application) is placed on the Row or Column axis, you can also specify which members in the Measures dimension should be on the y1 axis and which should be on the y2 axis. The y-axis split enables the chart to display two Y axes.

Dual axis and bipolar charts have two Y axes when the Y axis split is used. The Y1 axis is on the bottom part of the chart and the Y2 axis is on the upper part, as shown in the following dual-axis chart:

  1. Y2 axis
  2. Y1 axis
  3. X axis
  4. legend axis

This screen shot shows a dual Y axes bar chart, with Y1 axis on top representing cost of goods and Y2 axis on the bottom representing Sales. On the bottom are the time dimension on the X axis, and the product dimension on the legend.

The Measures dimension can appear on the X axis, filter, or legend. However, the Measures dimension usually appears as the legend. This makes it easier to distinguish which 1st and 2nd Y Axis items belong to each Measures dimension.

To split the Y axis when the Measures dimension is on the Row or Column axis:

  1. Click on the Charts button.
    The Chart Types dialog box appears.
  2. Click the Axes Placement tab.
    If the Automatically Assign Chart Axes check box is selected, the chart will assign the axis for the grid members automatically. If you want to assign the axes manually unselect this check box.
  3. Select y-axis or y-axis split for each dimension member you want to appear on that axis.
  4. Click the OK button to close the dialog box and implement the changes.
    The application updates immediately to reflect the changes.

When you click the Apply button the changes are implemented but the dialog box remains open.


Related Topics: