Excel: Chart – Pie

Pie: Comparing Distributions of Data

Pie charts provide a mechanism to compare distributions of data within a circle with the different categories touching each other.

In this example, I’ll begin with a data set describing four medicines and their effectiveness.

To create a bar chart, I’ll highlight the data set, use the Insert Menu and click the pie icon, then the 3-D Pie chart.

As you can see, the most effective medication is Med D and the least effective, Med B.
The margins between Med A and Med C are too close to see the difference so I’ll add data values to the graph.

Now I can see the difference between Med A and Med C – 10%.

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