Excel: Chart – Area

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s