Line Charts

Line charts show trends in data at equal intervals and are effective for comparing highs and lows in a continuum. In a line chart, items in the y axis determines the height of the line, and items in x axis itemize the line sections. You can create multiple lines by adding items to z axis.

Line charts have one advantage over bar charts. They do not enable one set of data to obstruct the representation of another. Since lines are thin compared to bars, the data displayed in the front does not block out the data behind.

As a result, data that is not easily represented in bar or area charts work well in line charts. Many more dimensions of data can be superimposed without impairing the effectiveness of the chart.

Note:

A line chart can have two different looks depending on if the chart was switched from a stacked or non stacked chart. If a line chart was switched from a stacked chart, the z axis items on the chart are stacked. If a line chart was switched from a non stacked chart, the z axis items are not stacked and are displayed as originally created.

  To create a standard line charts y axis:

  1. Select Line from the Chart drop-down list box.

  2. Drag a value item from Elements to the Facts pane in the data layout.

  3. Drag label items from Elements to the X pane in the data layout.

  4. Drag items from Elements to the Depth pane in the data layout.

  5. Select Legend On Facts (Depth) from the Legend drop-down list box to distribute colors along the z axis.

  To show line values, click a line and select Show Line Values on the shortcut menu.

  To show marker border, click a line and select Show Marker Border on the shortcut menu.