cellMatrix.net
Spreadsheet Modeling and Related Topics

About

Formulas, Charts, and Models Created with Microsoft Excel.
More . . .

Statistics

  • Total Entries - 102
  • Current Viewers - 12

Categories

Recent Comments

Syndicate

Validate

Why Use Pie Charts?

I try to spend a few minutes each day in the Microsoft Excel Charting forum and it seems like each day someone has a question about pie charts. Today a question was brought up about overlapping data labels in a pie chart with 13 data points. Who cares about the labels . . . what can you see in a pie chart with 13 points? Why do people use pie charts?

This quote is brought to us courtesy of Juice Analytics. Coda Hale writes:

Piecharts are for middle management. Piecharts are the information visualization equivalent of a roofing hammer to the frontal lobe. They have no place in the world of grownups, and occupy the same semiotic space as short pants, a runny nose, and chocolate smeared on one’s face. They are as professional as a pair of assless chaps. Anyone who suggests their use should be instinctively slapped.

For the record, I avoid pie charts like the plague. I've never seen a case where a pie chart performed better than a bar chart or a simple data table.

Below are links to sources that explain how pie charts should and shouldn't be used. They also describe the data visualization problems associated with pie charts. Additional links would be appreciated.



John:

Here’s a link to Jorge Camoes’s post on Pie Charts.

link

Jorge has an impressive Excel chart collection that you should find interesting.

While pie charts get picked on quite a bit, many Excel chart users misuse clustered/stacked bar charts which also have data visualization issues.

Charting Multivariate Data With Excel

Several Excel MVPs have tutorials and fancy tricks for clustered and stacked bar/column charts without any mention of the data visualization problems with these charts.

There are alternatives to stacked/ clustered charts that I’d like to see the Excel MVPs suggest to Excel Chart Forum readers so that they are at least aware of the potential shortcomings of these charts for multivariate data.


Kelly O’Day

Posted by Kelly O'Day  on  11/15  at  11:02 AM

Kelly,

Thanks for the link and for the information that you’re providing.  I need to spend some more time going through your site as it is an outstanding resource.

I’ve added your RSS feed to my site and will be looking forward to the updates.

Thanks again.

John Mansfield

Posted by John Mansfield  on  11/25  at  07:25 AM


Comment Form

Name: (Required)
E-Mail Address: (Optional)
Location: (Optional)
Web Site Address: (Optional)

Remember my personal information?
Notify me of follow-up comments?

Before submitting your comment, please enter the phrase you see below: