TL;DR:
Bars encode value by length, so a bar axis must start at zero or the lengths mislead.
Label the chart so a reader can understand it without you: a title that states the message, axis titles with units, and direct labels.
One chart, one message. Cut everything that does not support it.
A chart is a claim. Whoever reads it will trust the picture before the numbers, so a chart can mislead without containing a single wrong number. This guide shows how to build the most common chart, a bar chart, so that what the eye sees matches what the data says.
When a chart helps, and when a table is better
Use a chart when the point is a comparison, a trend or a shape, and the reader should see it in seconds. Use a table when people need exact values or will look up one item. If you have only two numbers, a sentence often beats a chart.
Match the chart to the question. Comparing categories (which product sold most) calls for bars. Change over time (how did sales move across twelve months) calls for a line. Parts of a whole across just two or three pieces can use a stacked bar, and many pie slices are hard to compare.
Prepare before you click Insert
Write the message as one sentence first, for example: product C leads, but only by a modest margin.
Put the data in two columns: labels on the left, numbers on the right, with a header over each.
Sort bars from largest to smallest unless the categories have a natural order such as months.
Know the units (units sold, dollars, hours), because they go on the axis.
Build it step by step
Select the labels and the numbers: Drag across both columns including headers, then insert a column or bar chart from the Insert menu of Excel or Google Sheets.
Set the value axis to start at zero: Open the axis options (right-click the vertical axis and look for format or customize axis). Set the minimum to 0 rather than leaving it on automatic.
Title the chart with the message: Replace a title like Sales with one that says something, for example Product C sold the most units.
Label the axis and add direct labels: Add the unit to the axis title, and switch on data labels so values sit on the bars. Then remove gridlines you no longer need.
Remove clutter: Delete the legend if there is one series, drop 3D effects and shadows, and use one calm color, with a second one only for the bar you want noticed.
Worked example: a bar chart with an honest axis
Say a shop sold 48 units of product A, 52 of product B and 60 of product C last month.
Product | Units sold |
|---|---|
A | 48 |
B | 52 |
C | 60 |
Spreadsheet apps sometimes pick an automatic axis that starts well above zero, say at 40. Look at what that does to the bar lengths.
Product | Real value | Bar length if axis starts at 40 | Bar length if axis starts at 0 |
|---|---|---|---|
A | 48 | 48 − 40 = 8 | 48 |
B | 52 | 52 − 40 = 12 | 52 |
C | 60 | 60 − 40 = 20 | 60 |
With the axis starting at 40, bar C is 20 units long and bar A is 8, so C looks 20 ÷ 8 = 2.5 times as long as A. The real ratio is 60 ÷ 48 = 1.25, so C sold one quarter more, not two and a half times as much. The eye reads the length of a bar as its value, which is why a bar axis must start at zero. From zero, the lengths 48, 52 and 60 give the same ratio as the sales: 1.25.
The honest chart has a zero baseline, bars sorted from largest to smallest, the title Product C sold the most units last month, the axis title Units sold, and the values 60, 52 and 48 written on the bars. It still shows that C leads. It just does not exaggerate it.
When zero is not required
The zero rule applies to bars and areas, where length or size stands for the value. A line chart shows position and slope, so its axis can start higher when changes are small compared to the level, as long as the axis labels are clear. Even then, say so if the range could surprise a reader. Never cut a bar axis, and never break an axis without clearly marking it.
Labels and one message per chart
Direct labels beat legends because the eye does not have to travel. Spell out units, such as Units sold or Hours per week, rather than leaving a bare number. Use plain text for category names, and horizontal bars if the names are long.
Give each chart one job. If you want to show sales by product and also sales by month, make two charts. A chart that tries to say four things usually says none of them. Ask of every element, does this support the message? If not, delete it.
Common ways charts mislead
A cut-off bar axis, as shown above.
Uneven intervals. If dates are spaced unevenly, a line chart that treats them as equal steps bends the trend.
Dual axes with different scales. Two lines can be made to cross anywhere you like. Avoid them, or label both axes very clearly.
3D bars and pie slices. Perspective makes front items look larger.
Color that implies a ranking. A bright color on the wrong bar sends the eye there.
A short checklist before you share
Read the chart as a stranger would. Can you tell what is measured, in what unit, and over what period? Does the title state the point? Does each bar's length match its number? If you want a second pair of eyes, you can show DuckyHelper the chart on screen by pressing its key and ask out loud what it seems to claim, then compare that against what you meant.
Frequently asked questions
Should every chart start at zero?
Bar charts, yes. Line charts can use another starting point when the changes would otherwise be invisible, if the axis is clearly labeled.
Is a pie chart ever fine?
With two or three slices and clear labels, it can work. With many slices, a sorted bar chart is easier to read.
Get started
