Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them
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.
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.
- For iPhone or iPod or iPad: Click here to subscribe.
- Andriod Phones & Tabs: Click here to subscribe on Stitcher. (You can download Stitcher free app from that link)
- Windows Phone: For Windows phone, search your podcasts app for our show.
- Or… As always, you can get latest episodes, show notes & resources from our Podcast page.
This sessions is all about pies, donuts, bars & bubbles. Yummy, I say!
You will learn,
- 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
Books mentioned
- Information Dashboard Design by Stephen Few
- Information Dashboard Design [first edition]
Articles & Discussion on Pie Charts
Good examples of Pie charts
- A good example of pie chart that works
Bad examples of Pie charts
- Nightmarish Pie charts
- Why 3D pie charts are evil
Debatable examples of Pie charts
- World polls chart – pie + donut – interesting but questionable
- Pie of a pie of a pie chart – interesting but avoidable
Alternatives & Improvements to Pie charts
- Alternatives to Pie charts
- Donut + Bar chart
- Grouping smaller slices in pie chart
Extra resource:
- How to pick right chart for your analysis
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.
- Subscribe to our podcast on iTunes
- Please leave an honest review on iTunes by clicking here.. It will help the show & its rankings immensely. Thank you so much.
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.
The post CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.