Area chart. Now, we are going to look at the more advanced and specialized use of charts and graphs in Excel. An area chart is an enhanced version of a line chart. In this chart type, the area below the plot line is solid. Like line charts. Area charts are used primarily to show trends over time.

Area charts are ideal for clearly illustrating the levels of change between two or more data points by graphically displaying the sum of the plotted values. An area chart also shows the relationship of parts to a whole