How to Make a Bar Graph in Google Sheets: Step-by-Step

To make a bar graph in Google Sheets, select a table containing category names and values, choose Insert > Chart, then set Chart type to Bar chart in the Chart editor. A bar graph displays categories as horizontal bars, making it easy to compare amounts and read longer category names. You can then add a title, labels, and other formatting before sharing or printing the chart.

What You’ll Need

A Google account and Google Sheets open in a web browser.
A spreadsheet with one column of category names and one or more columns of numeric values.
A clear idea of what you want readers to compare, such as monthly expenses, product sales, or survey responses.

You do not need a special template or a formula to create a basic bar graph. For example, enter this small table, with the category names in column A and the amounts in column B:

Category	Items sold
Apples	24
Oranges	18
Pears	31
Plums	12

Step-by-Step

Arrange your data in a simple table. Put a single heading at the top of each column. Place the categories in the first column and the corresponding numbers in the next column, with one category per row. Keep the data continuous, without blank rows or columns inside the table. In the example, Category and Items sold are the headings, while each fruit and its count make up one data row. If you have multiple series to compare, put each series in its own column with a heading, and keep the category labels in the first column.
Check that the values are usable numbers. Click a few cells in the values column and make sure they are numbers rather than text that only looks numeric. Avoid typing units into every value cell: use 24 rather than 24 items, for example. You can explain units in the column heading or chart title. If the values are percentages or currency, format the cells using Format > Number and select an appropriate format before charting.
Select the complete data range. Click the first heading cell, then drag to the last value cell to highlight both headings and all data rows. With the sample table, select A1:B5. Including the headings helps Sheets identify what the series and categories represent. If your data has several value columns, include all of them along with the category column. Be careful not to include unrelated notes or totals below the table unless you intend those to appear as bars.
Insert a chart. With the range selected, click Insert > Chart in the top menu. Sheets creates a chart and opens the Chart editor, usually in a panel on the right. It may initially choose a column chart or another chart type automatically; that is normal. The chart is linked to the selected cells, so later edits to the source values can update the graph.
Choose the bar chart type. In the Chart editor, open the Setup tab. Select the Chart type menu, then choose Bar chart. Use the standard Bar chart for ordinary comparisons. A Stacked bar chart is useful when each category has multiple components that should add up to a total; a 100% stacked version compares proportions. For a basic list of fruit counts, use the standard bar chart rather than a stacked option.
Confirm the labels and series. In Setup, check that the category names are used as labels and the numeric column is listed as the series. Sheets often detects this correctly when the headings and range are clear. If the chart shows generic category numbers or treats a heading as a data point, confirm the data range and use the options for using the first row as headers and the first column as labels. If the categories and series appear reversed, try Switch rows/columns, then check whether the result matches the way your table is organized.
Give the graph a useful title. Open Customize in the Chart editor, then open Chart & axis titles. Use the title-type menu to choose Chart title and enter a concise title that says what the values show, such as Items sold by fruit. A good title supplies context that category labels alone may not provide. Add an axis title when readers might not know what the numbers measure; for example, label the value axis Items sold.
Make the values easier to read. In Customize, open Series and select Data labels if the values should appear beside or within the bars. This works well for a small number of bars, but can make a crowded graph harder to read. You can also adjust the series color in this area. Choose a color with enough contrast against the background and use consistent styling when the graph belongs to a larger report.
Review the scale, order, and layout. Look at the value axis to make sure it covers the data without hiding meaningful differences. If needed, use Customize > Horizontal axis to adjust the minimum or maximum for a bar chart, taking care not to make comparisons misleading. To change the order of bars, sort the source table by its value column; the chart generally follows the source order. Drag the chart by its edge to move it, or drag a corner to resize it. Click outside the chart when finished editing.
Check the graph in context. Compare each bar with the source table and verify that every category appears once and the values are correct. If you are sharing the spreadsheet, check that the chart is large enough to read on screen and that the title and labels are visible. Google Sheets saves changes automatically. To make a copy for a document or presentation, use the chart’s three-dot menu and choose Copy chart, then paste it into a compatible Google file.

Common Mistakes

Selecting only the numbers: Without the category column, a chart may show generic labels such as 1, 2, and 3. Select the labels and values together, including the header row.

Mixing text and numbers: Entries such as 10 units or $20 typed inconsistently into cells can be interpreted as text. Keep the values numeric and apply number formatting separately.

Including totals unintentionally: A total row is often much larger than the individual categories and can flatten the other bars visually. Exclude it from the selected range unless comparing the total is part of the purpose.

Choosing a stacked chart by accident: Stacked bars communicate parts of a whole or combined values, not always straightforward comparisons between individual observations. Choose a standard bar chart when each row is one independent amount.

Adding too much decoration: Too many colors, gridlines, labels, or a long title can compete with the data. Keep the graph focused on the comparison readers need to make.

Tips

Sort categories by value when the point is to rank them. Sorting the data table from largest to smallest often makes the pattern easier to scan; the bar order follows the table.
Use a horizontal bar chart when category names are long. It gives labels more room than a vertical column chart, which can require tilted or shortened category names.
Use the same value scale when comparing separate charts. Different axis limits can make similar values look dramatically different.
Keep category names brief but specific. Names such as Q1, Q2, and Q3 need a chart title or other context to explain what is being measured.
For a presentation, enlarge the chart and reduce unnecessary spreadsheet clutter. For a printed page, check the print preview so the graph and labels are not clipped.
When you need to compare several groups within each category, use a grouped bar chart if that matches the data. Use stacked bars only when the combined totals or category composition matter.

Google Sheets uses the term Bar chart for the horizontal version. In Excel, the comparable choice is usually Insert > Insert Column or Bar Chart, then a Bar option. The menu names differ, but both programs can make horizontal category comparisons from a table of labels and values.

Troubleshooting

The graph is blank or has no bars: Reopen the Chart editor’s Setup tab and inspect the data range. Make sure it includes numeric cells as well as the category labels, and remove accidental blank rows within the range. If values were imported, select the cells and check whether they are stored as numbers rather than text.

The categories show as numbers: Edit the chart’s data range so the category column is included. In Setup, check the first-column-as-labels option if it is available. Confirm that the label cells are not empty.

The chart has the wrong orientation or grouping: Choose Bar chart again under Setup > Chart type. If the bars represent the wrong columns, use Switch rows/columns or correct the selected range. For a single category column and a single value column, there should generally be one bar per data row.

The bars look identical or the values seem wrong: Compare the plotted bars with the original cells, check for duplicate or unintended rows, and confirm the number format. A minimum value other than zero can exaggerate visual differences, so review the axis settings and reset the scale if needed.

Labels or values are hard to read: Resize the chart, shorten category names, or remove data labels that overlap. If the title or axis labels are missing, go to Customize > Chart & axis titles and select the relevant title type. For many categories, consider whether the chart is too crowded and whether a filtered or smaller data set would answer the question more clearly.

Frequently Asked Questions

What is the difference between a bar graph and a column graph in Google Sheets?
A bar chart uses horizontal bars, while a column chart uses vertical bars. Both compare values across categories; horizontal bars are often easier to read when category names are long.

Can I create a bar graph with more than one data series?
Yes. Put each series in a separate value column with its own heading, select the full table, and insert a bar chart. Sheets can display series side by side or stacked, depending on the chart type and settings.

How do I show the exact number on each bar?
Open the Chart editor, choose Customize > Series, and turn on Data labels. If the labels overlap or crowd the chart, turn them off or make the chart larger.

How can I change the order of the bars?
Sort the rows in the source table into the order you want, such as largest to smallest. The chart uses the table’s category order. If the ranking looks reversed, check the sort direction and axis settings.

Will a bar chart update when I change the spreadsheet values?
Yes. A chart connected to its source cells normally updates when those values change. If you add new rows outside the chart’s data range, edit the range in Setup so the new categories are included.

Can I make a bar graph in the Google Sheets mobile app?
Sheets supports chart creation in its mobile apps, but the controls and editing options can differ from the browser version. The steps here use Google Sheets in a web browser, where the Chart editor provides the full Setup and Customize panels.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.