Assigning a measure to a secondary axis

Sometimes plotting two measures on the same axis doesn't show the bars because of their relative values, or because of their incompatible units of measurement. To be able to clearly see both a line and bars in a Combo chart, CDP Data Visualization enables you to specify a different axis for each of the measures in the bar and line chart.

To demonstrate how to specify a different axis for each of the measures in the bar and line chart, create a Combo chart and follow these steps:

  1. To assign the GDP per Capita to the secondary axis, click the (down arrow) icon 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.

    Figure 1.
    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.