fbpx
Search
Close this search box.

CP041: 6 charts you’ll see in hell – v2.0

Share

Facebook
Twitter
LinkedIn

In the 41st session of Chandoo.org podcast, Let’s take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article – 6 Charts you will see in hell.

6 charts you should avoid - Chandoo.org podcast - session 41

What is in this session?

In this podcast,

  • Quick announcement about Awesome August
  • 6 charts you should avoid
  • 3D charts
  • Pie / donut charts with too many slices
  • Too much data
  • Over formatting
  • Complex charts
  • Charts that don’t tell a story
  • Conclusions

Listen to this session

Click here to download the MP3 file.

Learn more about which charts to avoid, which ones to make

On Pie charts:

Here is an ugly, clumsy pie chart to prove the point. [ Source: Bill the Lizard ]

What people are saying about your pie charts

 

On making charts when you have too much data:

On formatting:

Transcript of this session:

Download this podcast transcript [PDF]

Do you create any of these charts? Share your story

As a fresh analyst, I created all of these 6 charts. But I quickly realized that each time I made a 3D pie chart, I am selling a small piece of my soul to the devil. So I atoned my sins by scattering everywhere and visiting lots of bars. 😉

What about you? Have you ever created any of these charts? What did your users say when they saw these charts? Share your story in the comments.

Note: This is a part of Awesome August Excel festival.

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.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

5 Responses to “CP041: 6 charts you’ll see in hell – v2.0”

  1. Kris says:

    I enjoyed listening to pod cast
    CP041: 6 charts you’ll see in hell – v2.0

    I recommend others to listen

    Thanks for educating the community

  2. Heather says:

    Love the pie chart you've shown, I have a coworker who needs to see that.

    I personally am no fan of pie charts, and I'm still struggling to convince some of our team that we need to get rid of the 3D pie that is used in several of our reports. One trick that seems to be starting to work for this is to pair the chart with a more appropriate chart showing the same data (usually a bar chart). A few people are starting to see the light! 🙂

    Oh, and I loved the post back to the Gangnam styles - it's fun to see the 'wackier' side of Excel sometimes.

  3. Arve Kvalvik says:

    Keep ut The good work! I enjoy The way you solve problems and how you explain / teach 🙂

    Best regards Mr Arve Kvalvik, Norway

  4. cinnabar says:

    Nice post. You did not talk about custom charts in excel or will this be in "Charts you'll see in hell v3" ? 🙂

  5. Shoyeb says:

    Thanks for podcast. I really enjoyed it. ????

Leave a Reply