Help Topics

Assigning Members to Specific Axes (Multidimensional Data)


You can use the Chart > Axes Placement... option in the menu bar to control the axis on which each member is charted. The default axis placements are based on the grid and data layout panel. Changes made to the chart axes do not affect the grid or data layout panel.

Note

The drop down lists control the placement of the members currently on the Row and Column axes. If one of these is the Measures dimension, additional drop down lists on the right side of the tab control the y-axis placement of Measures and each of its children.

In the example below:

  1. Measures is assigned to the Y axis.
  2. The All Locations dimension is assigned as the filter axis, appearing as a drop down list for selection.
  3. All Time Periods is assigned to the X axis
  4. All Products is assigned to the legend axis.

This screen shot shows a vertical bar chart with each bar in the chart representing a product. The bars are in two groups. The first group on the left shows the measures for the five products in year 2000. The second group on the right shows the measures for the five products for year 2001.

To assign members to axes:

  1. Under the Axes Placement tab in the Chart Types and Configuration dialog box, clear the Automatically assign chart axes check box if it is selected.
  2. Using the drop down lists, select the axes for each dimension member. With bipolar and dual-axis chart types you can split the Y axis into the 1st and 2nd Y axes.
  3. Click OK to close the dialog box and implement the changes. Click Apply to implement the changes without closing the dialog box.
Note

The Chart > Axes Placement... option is the same as choosing Chart > Types > More... and clicking the Axes Placement tab.

For more information on axes placement, click the desired item:


Related Topics: