fbpx

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

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
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.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
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

Chandoo is an awesome teacher
5/5

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

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

20 Excel Templates

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

Weighted average formula in excel

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.

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