Pros

Simple presentation; easy to read and create Good for showing trends over periods of time Can handle positive and negative values

Cons

Don’t usually work well for multiple data series Line can imply more data than actually available (compared to bar or column chart)

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.   

Area Chart - 5Area Chart - 5Area Chart - 83Area Chart - 13