Paste two columns or ten: each extra column becomes a series next to the first. Download the bar graph as SVG or PNG with no account and no watermark.
How to make a bar graph
- Put the names in the first column and the numbers in the second. Add a column for each extra series you want to compare.
- Paste the cells in the Data panel, or type over the sample table.
- Choose vertical or horizontal bars, and whether several series stand side by side or stacked.
- Turn on value labels if the exact numbers matter, set the number format, and download.
One series or several
A single column of numbers gives one bar per label, all in the same colour. That is deliberate: the labels already tell the bars apart, and a different colour for each bar would suggest a difference that is not in the data.
Two columns give a double bar graph, the usual way to set this year against last year or plan against result. Each series gets a colour and a legend entry. Past four series the groups become crowded; at that point stacked bars or a line graph usually reads better.
Details that make a bar chart readable
- Start at zero. The bar’s length is the message, so the axis always includes zero here.
- Sort when the order is yours to choose. Products, countries and survey answers have no natural order, so sort them by value. Months and age groups do have one: leave them as they are.
- Go horizontal for long names. Tilted labels are harder to read than a horizontal bar with the name beside it.
- Label the bars or keep the grid. With value labels on every bar, the grid lines add little and can be switched off.
- Format the numbers. 1,250,000 is easier to read as 1.3M, and a share is clearer with a percent sign.
When a bar chart is the wrong choice
For a trend across many dates, bars turn into a fence; use a line graph. For the relation between two measures, use a scatter plot. For a single whole split into three or four parts, a pie chart says “parts of a whole” at a glance, although sorted bars are still easier to compare.