Assigning a Measure to a Secondary Axis

As we just demonstrated, sometimes plotting two measures on the same axis doesn't work because of their relative values, or because of their incompatible units of measurement. The following steps demonstrate how to specify a different axis for each of the measures in the bar and line chart.

  1. To assign the GDP per Capita to the secondary axis, click the icon (down arrow) on the GDP per Capita field.

  2. Select Axis, and then select Secondary Axis.

    assigning GDP to the secondary axis
  3. Click Refresh Visual.
  4. Notice that the both the blue bars ad the orange line are now clearly visible.

    The graph lists Life Expectancy on the left-hand vertical axis, in the range of 0 through approximately 70, and the GDP per Capita on the right-hand vertical axis, in the range of 0 to just under 14k.

    Life Expectancy and GDP per Capita on different axis
  5. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.

  6. Change the title to World Population - Dual Bar and Line.
  7. At the top left corner of the Visual Designer, click Save.

    clicking to save