Exceljet

Quick, clean, and to the point

Line Chart

Excel line chart example

A line chart is a built-in Excel chart type, with each data series plotted as a separate line. Line charts are a good way to show change or trends over time. In contrast to column or bar charts, line charts can handle more categories and more data points without becoming too cluttered. Line charts can be customized to show or hide data markers of various shapes and sizes.

Pros

  • Simple presentation; easy to read and create
  • Clean presentation of multiple data series with many data points
  • Good for showing trends over periods of time
  • Can handle positive and negative values

Cons

  • Harder to read when lines overlap frequently
  • Line can imply more data than actually available (compared to bar or column chart)