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)

…Read more Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Line Chart - 27Line Chart - 96Line Chart - 42Line Chart - 2Line Chart - 29Line Chart - 16Line Chart - 80