Please see me my other Excel articles.

Area Chart: Comparing Distribution Changes Between Data

When comparing data distributions, there are times when it’s important to compare differences between categories at certain data points.

In this example, I’ll begin with a data set comparing differences between school subject fees accumulated between two fiscal years.

To create an Area Chart, I’ll highlight the data set, then use the Insert Menu and click the Area chart icon.

As you can see by the areas illustrated, overall between the subjects a drop in fees was experienced between the first year and the next.
The least difference in fees between fiscal years was from Math and History the greatest.
Science and English experienced similar amount of drop in fees.