• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Best Types of Charts in Excel for Data Analysis

Shozab Mukhtar

New Member
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

Well-Known Member
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...