How to Make a Bar Graph: Data, Labels and Axis Settings
Learn how to make a bar graph step by step: prepare the data, pick vertical or horizontal bars, sort and label them, and avoid the axis and colour mistakes that mislead readers.
To learn how to make a bar graph, start with a small table: one column of category names and one column of values. For a sales report, those might be regions and quarterly revenue. The chart should make the comparison easy to see, with readable labels, a zero baseline and a useful order for the bars.
How to make a bar graph in five steps
- Write the question. "Which region sold the most last quarter?" is a bar graph question. "How did sales change week by week?" is usually a line graph question.
- Prepare two columns. Category labels in the first column, numbers in the second. Add more number columns only if you need to compare groups side by side.
- Choose the orientation. Vertical bars suit short labels and a handful of categories. Horizontal bars suit long labels or more than about eight categories.
- Sort the bars. Unless the categories have a natural order, such as months or age bands, sort from largest to smallest so the ranking is visible at a glance.
- Title it with the takeaway. "North leads, East lags" tells the reader what to see; "Sales by region" makes them work it out.
Start the axis at zero
A bar's length is its value, so the axis must start at zero. For example, values of 100 and 102 differ by 2%. If the axis starts at 90, their visible lengths become 10 and 12, making the second bar appear 20% longer. If the differences are genuinely small and that is the point, say so in the title or use a table rather than distorting the bars.
The same rule does not apply to line graphs, which show change rather than size; this is one of the few places where the two chart types behave differently.
Grouped and stacked bars
When you compare several groups across categories, you have two options. Grouped bars place the groups side by side within each category and make it easy to compare groups directly. Stacked bars pile them on top of each other and make it easy to compare totals, but hard to compare anything except the bottom segment. Choose based on which comparison matters more, and keep the number of groups to three or four. The current ToCharts maker supports grouped bars, but has no stacked-bar option; use another tool if a stacked view is required.
Labels, colour and clutter
Put value labels at the end of each bar when exact numbers matter; drop the gridlines if you do. Use one colour for all bars and a second colour only to highlight the bar you are talking about. Avoid 3D effects and decorative backgrounds when comparing lengths. They can obscure bar ends or distract from the scale.
Keep category labels readable without tilting them. If they need to tilt, switch to horizontal bars.
Make one in your browser
The bar graph maker in ToCharts takes the data in either form: type the values in, or paste a CSV or cells copied from Excel or Google Sheets, with the first column as labels. Switch between vertical and horizontal bars, add a second series for grouped bars, and download PNG or SVG. If you are not sure a bar graph is the right choice, the chart examples page walks through twelve worked examples with the reason each chart type was chosen.
What this can't do yet
The bar graph maker draws vertical, horizontal and grouped bars from values you provide. It has no stacked-bar mode or automatic sorting, so arrange rows in your spreadsheet first. It does not calculate totals or percentages for you. Each chart is made and downloaded in the browser; there is no server-side batch chart API.
Frequently asked questions
What is the easiest way to make a bar graph?
Prepare category names and values in two columns. Sort the rows in your spreadsheet first if you need a ranking, then paste them into the maker, add a title and download the chart.
Should a bar graph start at zero?
Yes. A bar's length represents its value, so starting the axis above zero exaggerates the differences between bars and misleads readers.
When should I use horizontal bars?
Use horizontal bars when category labels are long or when you have more than about eight categories. The labels stay readable without being tilted.
What is the difference between grouped and stacked bars?
Grouped bars show series side by side; stacked bars show their contributions to a total. ToCharts currently offers grouped bars, so choose another tool when you need a stacked chart.
How many bars can one bar graph have?
There is no strict limit, but beyond about 15 bars a sorted horizontal layout or a table usually communicates the ranking more clearly.