What is Your Opinion on Pie Charts?

Share

Facebook
Twitter
LinkedIn

Here is the big hairy question of the week. What is your opinion on Pie Charts?

Pie charts are one of the most used charts in the world. And for obvious reasons: they are simple to create and easy to understand.

When it comes to pie chart, I have no clear opinion. Part of me says use them, the other says avoid them. The debate about pie charts is not just internal. Last time when Seth Godin included pie charts in his 3 laws of great presentation,

The problem with bar charts is that they should either be line/area charts (when graphing a change over time, like unemployment rates) or they should be a simple pie chart (when comparing two or three items at the same scale).

there was so much furor in the data visualization blogosphere that Seth even did a follow up post comparing bars with pie charts, where he says,

The pie chart contains far less data, but the point is obvious: Trolls are where we should focus our energy.

That’s why you use it.  …

I stepped on the toes of many data presentation purists yesterday, so let me reiterate my point to make it crystal clear: In a presentation … the purpose of a chart or graph is to make one point, vividly. Tell a story and move on.

Personally I think pie charts provide great utility at very little cost:

  • They are very easy to create
  • Very very easy to understand (provided the data has some contrast, if your numbers are like 43,44,45,46, there is little chance that anyone can understand the resulting pie chart and make out which one is large and which one is small)

But, I also think they are easy to abuse (one reason why you see way too many pie charts compared to other charts).

Here is what I think cripples a pie chart from being effective:

    Pie Charts with too many values

  • Too many data points. A pie chart would probably be effective up to 4 values, anything more and you better have a strong story behind it for people to read and interpret. For eg. the pie chart shown to the right is used in Google Analytics reports. This compares browsers used by visitors of a site and even though there are probably hundreds of browsers, only 2 are prominent, so the pie still works.
  • Pie Charts - What colors to use?Poor use of color. The purpose of color in most visualizations is to bring contrast. To separate apples from oranges. To throw light where your story lies. But most programs that are used to generate pie charts have poor (and often scary) color choices. When you use poor color combinations, the result will be drastic. But this blame is not on the person making pie charts, but on the pie chart software. See the example aside from clearlyandsimply to see what contrast means.
  • Making Pie charts that are difficult to compare. The purpose of pie charts is to provide comparison. So when we make a pie chart that has poor ability to compare, we are already lost. That means we should avoid all the flashy formatting, 3d pie charts, 3d donuts and layered donuts etc. Also, whenever possible, try Using data labels, using color and if nothing works, try using other types of charts for comparison. After all, we are not selling pie charts, we are selling our stories.

Ok, now the ball is in your court (or the pie is in your plate).

What do you think about pie charts?

Do you prefer them or do you consciously avoid them ?

How do you think pie charts can be put to better and greater use ?

Your turn…

Earlier on pie charts: Why no one likes your pie & what to do about it? | In cell pie charts | 22 beautiful pie chart templates for excel

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

11 Responses to “Fix Incorrect Percentages with this Paste-Special Trick”

  1. Martin says:

    I've just taught yesterday to a colleague of mine how to convert amounts in local currency into another by pasting special the ROE.

    great thing to know !!!

  2. Tony Rose says:

    Chandoo - this is such a great trick and helps save time. If you don't use this shortcut, you have to take can create a formula where =(ref cell /100), copy that all the way down, covert it to a percentage and then copy/paste values to the original column. This does it all much faster. Nice job!

  3. Jody Gates says:

    I was just asking peers yesterday if anyone know if an easy way to do this, I've been editing each cell and adding a % manually vs setting the cell to Percentage for months and just finally reached my wits end. What perfect timing! Thanks, great tip!

  4. Jon S says:

    If it's just appearance you care about, another alternative is to use this custom number format:
    0"%"

    By adding the percent sign in quotes, it gets treated as text and won't do what you warned about here: "You can not just format the cells to % format either, excel shows 23 as 2300% then."

    • Steven Peters says:

      Dear Jon S. You are the reason I love the internet. 3 year old comments making my life easier.

      Thank you.

  5. Jon Peltier says:

    Here is a quicker protocol.

    Enter 10000% into the extra cell, copy this cell, select the range you need to convert to percentages, and use paste special > divide. Since the Paste > All option is selected, it not only divides by 10000% (i.e. 100), it also applies the % format to the cells being pasted on.

  6. Chandoo says:

    @Martin: That is another very good use of Divide / Multiply operations.

    @Tony, @Jody: Thank you 🙂

    @Jon S: Good one...

    @Jon... now why didnt I think of that.. Excellent

  7. sajith says:

    Thank You so much. it is really helped me.

  8. Winnie says:

    Big help...Thanks

  9. Chris Fry says:

    Thanks. That really saved me a lot of time!

  10. Texas says:

    Is Show Formulas is turned on in the Formula Ribbon, it will stay in decimal form until that is turned off. Drove me batty for an hour until I just figured it out.

Leave a Reply