Best Types of Charts in Excel for Data Analysis

[Shozab Mukhtar]

Hello Excel Community,

Creating charts and graphs without coding is a dream of many non-tech people.

I would love to share with you how to make charts in Excel with zero coding skills.

I am using ChartExpoTM for Excel to make 50+ types of charts in just few clicks.

I decided to post this thread after seeing many questions on internet specially from medical and finance field asking "How to create chart/What type of chart is suitable for their data?"

Sharing a video to show you how easy it is to create charts using ChartExpo: https://bit.ly/3q3dlJv





Visualization experts your feedback is much appreciated!

Thanks You!

 

[GraH - Guido]

What's the obvious message of these charts?
The second one would fall under the category "Great marketing, still crap chart" in my book.
The first one is slightly better, but I would stick to a simple pivot table overview when all the details and subtotals are important (which they are not).

Honestly, I'm not a fan!

For alternative 1, I suggest a simple bar chart, something like below...