Course / Charts

Line charts for trends

Draw two series over twelve months, name the axis, and see what an empty cell does to a line. Beginner · 4 min · Line chart, Series, Legend

A line chart shows how something changes over time. The eye follows the line, so rises, falls and turning points stand out in a way they never do in a column of numbers.

Each column of numbers in the data becomes its own line, called a series, and the legend under the chart says which is which.

Use a line when the order along the bottom means something: months, days, years. For separate things with no order, such as products or people, columns are the honest choice, because a line between them suggests a trend that isn't there.

Steps

  1. Select the whole table, A1:C13, click Chart, choose Line, and click Insert.

  2. Under Chart title in the Chart panel, type Orders by month.

  3. The numbers up the side could be dollars or orders. Under Vertical axis title, type Orders.

  4. Look at the right end of the Online line: it stops at November, because December's cell is empty. The figure has just come in: type 940 in B13.

Remember

Previous: Bar charts for long names · Next: Pie charts, and when not to use one