Bar
Google: “Use a bar chart when you want to compare individual items. For example, compare ticket sales by location, or show a breakdown of employees by job title.” Every bar starts at zero, so the lengths mean what they look like they mean.
Docs · guide
How to make a bar graph in Google Sheets, and lay out the data
By Alberto Gulotta · Updated · 11 min read
To create a bar graph in Google Sheets: select the cells, Insert › Chart, and if Sheets guesses another type, change it under Setup. The two things worth a page are what shape the data has to be in, and which of the three bar charts you actually want.
| What | What it becomes, or what it means | Source |
|---|---|---|
| First column | “A label for each row”, shown on the vertical axis | |
| Other columns | The numeric data; the values “show up on the horizontal axis” | |
| Each row | “Each row represents a different bar in the chart” | |
| Bar chart | The length of a bar is the value. Google: use it “when you want to compare individual items” | |
| Stacked bar | The length is the total of its parts | |
| 100% stacked bar | Every bar is the same length; only the mix changes |
- Lay the data out the way the chart reads it. Labels down the first column, numbers in the others, one row per bar. This decides the chart before you draw anything.
- Select the cells, labels included. They become the axis names and the legend.
- Click Insert, then Chart. Sheets draws something at once; treat it as a proposal.
- Double-click the chart, open Setup, and choose the bar chart you meant. Plain, stacked or 100% stacked are three different claims about the same numbers.
- If the bars and the labels are the wrong way round, switch rows and columns. Google’s own tip for exactly this: “if the chart doesn’t show the data on the axis you want, learn how to switch rows and columns”.
Google tells you how to lay out the data, and the layout is the chart
This is the part the tutorial pages skip, and it decides everything that happens next. Quoted from Google’s own page on bar charts.
- First column
- “Enter a label for each row. Labels from the first column show up on the vertical axis.”
- Other columns
- “For each column, enter numeric data. You can also add a category name (optional). Values show up on the horizontal axis.”
- Rows
- “Each row represents a different bar in the chart.”
Read the third one again, because it is the whole thing. A bar is a row. If your chart has four bars and you expected twelve, your figures are running across the sheet instead of down it — and Google gives the fix in a one-line tip: “If the chart doesn’t show the data on the axis you want, learn how to switch rows and columns.” Almost every “my chart looks wrong” question in Sheets is that sentence.
Stacked bar
Google: “Use a stacked bar chart to show part-to-whole relationships and find trends in data over time. For example, show how 4 office locations contributed to total sales.” The totals compare honestly; the bands inside do not, because only the first one sits on the baseline.
Google’s requirement: “at least 2 data series”100% stacked bar
Google gives the sharpest test of the three: use it “when you want to show the relationship between individual items and the whole in a single bar, and the cumulative total isn’t important”. That last clause is the decision. Every bar is the same length, so the totals are not merely hidden — they are gone.
Google’s requirement: “at least 2 data series”
And the shape is not a matter of taste. North Carolina State University’s graphing guide separates a bar graph from a histogram by what the data is, not by how it looks: “histograms are a specialized type of bar graph used to summarize groups of data”. Sheets will draw either over the same numbers without comment.
The three of them answer different questions, and the answers are not interchangeable. Plain bars answer which is biggest. Stacked answers what is each total made of, and how are the totals moving. The 100% version answers what is the mix and deliberately throws the size away. Choosing the third when you meant the second produces a chart where a division that halved in size looks exactly as it did before, because its share happened to stay the same.
Why bars rather than columns. Sheets offers both, and the difference is orientation rather than meaning. Horizontal bars carry long labels — department names, survey answers, product titles — as readable text, which is why Google’s own examples are things like “a breakdown of employees by job title”. Vertical columns suit short labels and anything read as a sequence over time.
What lives under Customize. Double-click the chart and the second tab holds the rest: chart style, titles, series colours, legend, and the two axes. Two of those entries are worth knowing about before you go hunting. Under Horizontal axis there is “reverse axis order”, which is the fix when your bars run the opposite way to your rows. Under Vertical axis you can “set min or max value” — and on a bar chart, that is the setting to leave alone.
Because on a bar chart the length is the value. Setting a minimum above zero cuts the bottom off every bar, and a rise from 92 to 96 can be drawn as one bar twice the height of another. The same adjustment on a line chart is a reasonable way to show detail, because a line encodes position rather than length. Sheets will let you do it either way and says nothing about the difference.
The layout rules, the descriptions of the three bar types, their data-series requirements and the Customize options above are quoted from Google’s own Docs Editors documentation, read on 22 August 2026 and listed below. The argument about the zero baseline is ours.
Where to start
Four ways in.
- “I just need a bar chart.”
- One sentence, above. Then check laying out the data
- “My chart has the wrong number of bars.”
- A bar is a row — laying out the data
- “Stacked or 100% stacked?”
- Google gives the test — the three bar charts
- “It has to go in a slide deck.”
- Read the warning first — sending it onward
Laying out the data
In Sheets the arrangement of the range is the chart. Most complaints about the chart are complaints about the range.
Line graphs in Google SheetsThe other chart in the same editor, and when it is the honest choice instead.Open this guide →
Graphs in Google SheetsThe chart can stay linked to the data — and Google warns it is then visible to people who cannot open the sheet.Open this guide →
Free alternatives to WordWhat each one does with a file somebody else has to open afterwards.Open this guide →
The three bar charts
Plain, stacked and 100% stacked answer three different questions, and Google states which is which.
Bar graphs in ExcelThe same three choices in the other spreadsheet, with Microsoft’s definitions and the reverse-order checkbox.Open this guide →
Graphs and charts in ExcelThe three decisions that separate a chart which shows something from one that merely appeared.Open this guide →
Pie charts in ExcelThree conditions before you should use one, and an admission that a pie cannot be read without labels.Open this guide →
Sending it onward
A Sheets chart can travel as a picture or as a live link, and the two behave very differently once other people can see it.
The numbers underneath
A chart is a picture of a range, and a wrong-looking chart is usually a right drawing of untidy data.
Percentages in ExcelThe formulas are the easy half. The format changes the number, and depends on when you apply it.Open this guide →
Percentage increaseA rise and the fall that undoes it are never the same number.Open this guide →
Removing duplicates in ExcelThree tools and only one deletes, and what Excel actually counts as a duplicate.Open this guide →
Questions people also ask
How do I create a bar graph in Google Sheets?
Select the cells with their labels, click Insert › Chart, then double-click the chart and set the type under Setup if Sheets guessed something else.
How do I make a bar graph with two variables?
Give each variable its own column and select both. Google’s layout rule does the rest: the first column becomes the labels, each further column becomes a series, and each row becomes a group of bars.
When should I use a 100% stacked bar?
When the mix matters and the totals do not. Every bar is drawn the same length, so a division that halved in size looks unchanged if its share stayed the same. If the sizes matter, that is the wrong chart.
Why are my bars and labels the wrong way round?
Because the chart is reading your rows as series and your columns as categories, or the other way about. Google’s tip covers it: “if the chart doesn’t show the data on the axis you want, learn how to switch rows and columns.”
Not covered here. It will not stop at Insert › Chart. Google publishes rules for how the data has to be arranged, and those rules decide what the chart shows.
It will not treat the three bar charts as styling. Google gives a different purpose for each, including the clause that settles when a 100% stacked bar is right.
And it will not recommend an add-on for something that is one item on the Insert menu. What holds instead is simple: the data layout rules and the Customize options are quoted from Google’s own Docs Editors help, read on the date this page names.
The same chart, in Excel and in Google Sheets
The chart is the same decision in both programs; only the menus differ. Which one you are in decides which guide to open.
- The same job, in the other places it comes up
- How to make a graph in Excel, and which one to pick
- How to make a graph in Google Sheets, and keep it live
- How to make a bar graph in Excel, and which kind
- How to make a line graph in Excel, and when not to
- How to make a line graph in Google Sheets, and fix the scale
- How to make a pie chart in Excel that people can read
Sources
- Google Docs Editors Help — Bar charts, including how to format the data, what each row becomes, when to use a stacked or 100% stacked bar, the two-series requirement and the Customize options — support.google.com, read 22 August 2026.
- Google Docs Editors Help — Add and edit a chart or graph, for the Insert route, the Setup tab and changing the chart type — support.google.com, read 3 September 2026.
- LabWrite, North Carolina State University — Graphing: bar graphs and histograms, on choosing the shape by what the data is rather than by how it looks — www.ncsu.edu, read 3 September 2026.
Written by Alberto Gulotta
Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.
Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.
Written on 22 August 2026 · last checked 23 September 2026.
Independence and limits
No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.
This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.