The 2-Value Axes tool integrates disparate data sets with different scales. The Enable 2-Value Axes feature allows for the visualization of these variables on the same metric.
To set this up, follow these steps:
- Import at least two data series into the metric.
- Click the three-dot menu for one of the data series.
- Enable the 2-Value Axes by selecting the Assign Data Series dropdown and choosing whether to assign the data series to the right or left axis.
Once one data series is assigned to the left axis and another to the right axis, the 2-Value Axes feature will be activated. This will result in the left and right sides of the metric displaying unique scales corresponding to their respective data sets. The title and number formatting of each axis are determined by the first data series assigned to that specific axis location.
On "Bar" and "Bar & Line" chart types, instead of assigning a data series to a the left or right axis you will assign the data series to the bottom or top axis. You also must have at least one data series assigned to the left axis or bottom axis (Bar and Bar & Line charts).
Charts That Support 2-Value Axes
You can use this feature on any series-type chart, except for any of the stacked-column type charts with the exception of the "Stack Column & Line" chart. The chart types below in green support this feature:
The "Stacked Column & Line" chart type works differently than other chart types. Any data series type that is assigned as a column will be assigned to the same axis. If the axis location is changed for one column data series type, it is changed all column data series type to match the changed axis location.