Skip to main content icon/video/no-internet

Line charts are ideally used to demonstrate trends for data and to show how one variable is affected by another variable. Data points are connected by lines. A minimum of three points is required to make a line.

None

Figure 1 Cost of Housing Over 5 Years

Figure 1 is a line chart illustrating the cost of homes (principal place of residence) and cottages in the past 5 years. This graph was created using Excel. Note that even though the graph is made of discrete sets of data points, a trend is implied.

The following are recommendations for creating a line chart:

  • Gridlines help the reader estimate the value of the points.
  • The x- and y-axes are clearly labeled.
  • A legend is necessary when more than one line is presented.
  • The legend may be placed outside or inside the chart.
  • Each line is different as well as the points that make up each line in order to easily distinguish one trend from the other.
  • Too many lines (particularly if they overlap) would make the chart difficult to read.
Adelheid A. M. Nicol

Further Reading

Bowen, R. W.(1992).Graph it! How to make, read, and interpret graphs.Upper Saddle River, NJ: Prentice Hall.
  • Loading...
locked icon

Sign in to access this content

Get a 30 day FREE TRIAL

  • Watch videos from a variety of sources bringing classroom topics to life
  • Read modern, diverse business cases
  • Explore hundreds of books and reference titles

Sage Recommends

We found other relevant content for you on other Sage platforms.

Loading