Derived Axis

You can add a secondary axis that is derived from another axis. For example, if you are working with currency data, you can display both U.S. dollars and euros as scale axes.

How to Add a Derived Axis

  1. Select the scale axis for which you want to create a derived axis. This is the primary axis. If no axis is selected, the Chart Editor creates a derived axis for all scale axes in the chart.
  2. From the menus choose:

    Options > Show Derived Axis

    The Chart Editor adds the derived axis opposite the selected axis, selects it, and opens the Properties window to the Derived Axis tab.

  3. Use the Derived Axis tab to specify the relationship between the derived axis and the primary axis. The range of the primary axis and the relationship between the axes determines the range of the derived axis.
  4. If necessary, use the Labels & Ticks tab to change the display of ticks and labels for the derived axis.
  5. Click Apply.
  6. If necessary, change the derived axis title, which you can edit as you edit other text in the chart. See the topic Editing Text for more information.

How to Remove a Derived Axis

  1. Select the derived axis.
  2. From the menus choose:

Options > Hide Derived Axis

Using the Derived Axis Tab

  • Ratio. Change the ratio of the primary axis unit to derived axis unit. For example, assume that the ratio of Euros to U.S. dollars is 1.1 to 1. Type 1 for the scale axis and 1.1 for the derived axis. (Conversely, if you knew that the ratio of U.S. dollars to Euros was 0.9 to 1, you would type 0.9 for the scale axis and 1 for the derived axis.) The ratio must be a positive number.
  • Match. Relate a specific position on the primary scale axis to a specific position on the derived axis. In other words, the derived axis is shifted in relation to the primary axis.