When building a chart, it may be useful to display time series on distinct axes. A typical use-case is when series are expressed in different units. The time charts you build in the application have two axes that series can be assigned to. This article will provide you with a quick overview of the alternative axis feature, as well as what to keep in mind when using it.
Setting the alternate scale
Like most of the charting functions, you start by clicking on a graphic element, a line or column for example, to select which series you want to work with. The alternate scale setting is found in the command bar, under the presentation properties tab.
You can also select which series should be shown on an alternate scale when working in the graph layout dialog.
Alternate Scale and Synchronizing axes
Using the Synchronize settings will affect the way in which the alternate scale is displayed. Below we go over the outcomes of combing these settings, below.
- Alternate Scale + Synchronize: None
Each axis has an independent scale and independent grid.
- Alternate Scale + Synchronize: Grid
Each axis has an independent scale, but both axes will share the same grid. You can’t adjust the step length of the axes, only the scale range.
- Alternate Scale + Synchronize: Values
Each axis will share the exact same scale and grid, which will void the outcome of applying an alternate scale.