MyMisPal
← BI lessons
Lesson 6 of 10

Choosing the right chart

A chart isn't decoration. Choosing one starts from the question: what should the reader grasp in 5 seconds?

Line: change over timeBar: comparisonStacked: parts of a wholeScatter: relationship
QuestionBest chartNakhla example
How did it change over time?LineMonthly sales
Which is biggest? Compare categoriesBarSales by region
What share of the whole?Stacked bar, or a pie for 2–3 parts onlyOnline versus stores
Is there a relationship?ScatterDiscount versus quantity sold
Needs the exact numberA table or a number cardToday's total sales

Mistakes that mislead: a bar chart whose vertical axis doesn't start at zero (a 2% gap looks like double), a pie with 12 slices, 3D charts that distort sizes, and many colours with no meaning.

Watch outUse colour to focus, not to decorate: make every bar grey and colour only the one you're talking about.
Spotted a mistake on this page, or have an idea to improve the site?