Please see me my other Excel articles.
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%.