Line Visuals with Dual Axis

It is often enlightening to see related dimensions on the same line chart; it clearly shows both correlation and pattern. However, values may be measuring completely different things, or the range of values (scale) is too different to show both lines clearly. Arcadia Enterprise offers a dual axis option for situations like these.

The following steps demonstrate how to create a line visual that uses a double axis; it is based on dataset World Life Expectancy [data source samples.world_life_expectancy].

  1. Start a new visual based on dataset World Life Expectancy [data source samples.world_life_expectancy]; see Creating Visuals.
  2. In the visuals menu, find and click lines, the fourth choice on the first row.
  3. Populate the shelves from the available fields (Dimensions, Measures, and so on) listed in the left navigation menu.

    • Under Dimensions, select year and place it on the X shelf.
    • Under Measures, select life_expectancy and place it on the Y shelf.
    • Under Measures, select population and place it on the Colors shelf.
  4. On the shelf of the visual, on sum(life_expectancy) field, click the icon (down arrow), select Aggregates, and then select Average.

    changing the aggregation of life expectancy
  5. Note that the shelf now contains the modified field avg(life_expectancy).

    life expectancy with avg aggregation
  6. Click Refresh Visual.

    The line visual appears.

    It is impossible to see the values on the life expectancy line because the population line sets the scale for the Y axis. In fact, the label does not correspond to the scale shown.

    Linear Plot of Population and Life Expectancy, on the Same Axis
  7. On the Colors shelf, on sum(population) field, click the icon (down arrow), select Axis, and then select Secondary Axis.

    Assigning a Measure to the Secondary Axis.
  8. Click Refresh Visual.
  9. The two lines can now be seen clearly.

    Notice that there is now a Y axis both on the left and the right side of the visual.

    For convenience, the color of the axis labels match the line.

    Linear Plot of Population and Life Expectancy, Each on its own Axis
  10. Change the title to World Population - Lines, Dual Axis.
  11. Save the visual.