fbpx
Search
Close this search box.

CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them

Share

Facebook
Twitter
LinkedIn

In the 4th session of Chandoo.org podcast, lets talk about Pie charts.

Pie charts evoke strong opinions among analysts & managers. Some people love them and can’t have enough of them in reports. Others despise them and go to any lengths to avoid them. And that is why we are going to talk about them in this session.

CP004: Can I Pie Chart in public? - Discussion about merits & drawbacks of Pie charts, whether you should use them or avoid.

Before we proceed in to the session, let me remind you:

Get new episodes automatically!

That is right. Chandoo.org uses latest & most magical software. That means, whenever I push the publish button, an army of unicorns & fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.

What is in this session?

This sessions is all about pies, donuts, bars & bubbles. Yummy, I say!

You will learn,
One of the many limitations of Pie charts - demo

  • Special, secret transmission from guest stars
  • What is a pie chart?
  • Why they work? 2 reasons
  • Why they don’t work ? 4 reasons
  • Cousins & siblings of Pie charts
    • Donut charts
    • Gauge charts (speedometer)
    • 3D pies
    • Area charts
    • Bubble charts
  • 4 Situations when making a pie chart is ok
  • Alternatives to Pie charts
  • Mistakes you should avoid
  • About the resources
  • Conclusions

Go ahead and listen to the show

Links & Resources mentioned in this session:

Books mentioned

Articles & Discussion on Pie Charts
Good examples of Pie charts

Bad examples of Pie charts

Debatable examples of Pie charts

Alternatives & Improvements to Pie charts

Extra resource:

Note about book links: The links to various books mentioned in this podcast are affiliate links. It means when you click on them & purchase, good folks at Amazon pay me a few cents. I recommend these books because I genuinely love them. I would have recommended even if there is no benefit to me.

Transcript of this session:

Click here to download the transcript.

If you enjoy the podcast…,

Please do these 2 things. It means a lot me & our community.

  1. Subscribe to our podcast on iTunes
  2. Please leave an honest review on iTunes by clicking here.. It will help the show & its rankings immensely. Thank you so much.

Do you use Pie charts?

I do not avoid them completely. Once in a while I like to throw a pie in to my dashboards. They are a great way to visualize data despite the pitfalls.

What about you? Do you use pie charts? Please share your experience using comments.

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

Excel School made me great at work.
5/5

– Brenda

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.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

4 Responses to “CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them”

  1. Jay says:

    hello mike testing 1 2 4....1 2 4, pie charts are 'not wolking' for me...so i don't use pie charts 😀

  2. AMBARISH N says:

    Really nice & informative...... keep it up......

  3. Martin Ryder says:

    I'm a software trainer. I've always loved your site. I've had to teach myself a lot of Excel, from scratch, to teach it. You've made that so much easier. Now you have these amazing podcasts. Thanks for all the work you've done to pass on your knowledge.

  4. jdogzilla says:

    Can't agree more with you ... 3-D charts totally distort data, and pie charts are very misleading. I hadn't put down a solid reason why I disliked (note I'm not saying hated) pie charts, but after hearing this podcast, I know my points of argument. Thanks!

Leave a Reply