Multiple Line Chart

Published on November 30, 2015

In this post, I’ll show you how to compare multiple measures in a single pane.

When you need to show multiple measures simultaneously, a line chart presents the relationship between them in a single visual. Where a single line chart displays information as a series of data points connected by straight line segments, a multiple line chart shows multiple measures—different measures, or subsets of a measure—for a comparison between them. You can convert a single line chart to a multiple line chart by simply dropping these additional measures onto the Colors shelf.

Let’s look at an example using the dataset Us County Population [data source(need URL)]. If you want to visualize a comparison between the total male population and minorities (such as the African-American and the Asian-American male populations) across US counties, you can create a multiple line chart that has three lines that represent these three measures.

The following steps demonstrate how to show multiple measures on a line chart.

  1. Create a Line Chart.
  2. While populating the shelves from the available fields (Dimensions and Measures) listed in the left navigation menu, drop measures into the Colors shelf.
    • Under Dimensions, select stname and drag-and-drop it to the X shelf.
    • Under Measures, select tot_male; and drag-and-drop it to the Y shelf.
    • Under Measures, select ba_male; and drag-and-drop it to the Colors shelf.
    • Under Measures, select aa_male; and drag-and-drop it to the Colors shelf.

    image00

  3. Click Refresh Visual.
    The multiple lines visual appears.

Note that the color legends on the top right of the visual show that the red line represents the total male population, the yellow line represents the African-American male population, and the green line represents the Asian male population.

image01