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/
CP041: 6 charts you’ll see in hell – v2.0
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.
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
Click here to download the MP3 file.
Learn more about which charts to avoid, which ones to makeOn Pie charts:
Here is an ugly, clumsy pie chart to prove the point. [ Source: Bill the Lizard ]
- Should you use pie charts? – podcast session 004
- Why 3D pie charts are evil
On making charts when you have too much data:
- Panel charts (or small multiples) in Excel
- Panel Chart case study – Survey results visualized
- Sparklines
On formatting:
- Avoid Gangnam styles
- Impressing your boss with Excel charts – 6 step road map for you – podcast session 029
Download this podcast transcript [PDF]
Do you create any of these charts? Share your storyAs 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.
The post CP041: 6 charts you’ll see in hell – v2.0 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.