Creating a bar graph in Google Sheets takes four steps: select your data, open the chart tool, choose the bar chart type, and customize the labels
A bar graph displays data as vertical or horizontal bars, making it straightforward to compare values across categories. Google Sheets builds the graph automatically once you select the numbers and labels you want to show. You do not need to know formulas or use a separate program — the chart tool is built into Sheets and works the same way whether you are on a computer or phone.
The process works best when your data is organized in columns or rows with labels in the first column or row and numbers in the columns or rows next to them. If your data is scattered across the sheet, take a moment to group it together first. The cleaner your layout, the faster Sheets will recognize what to chart.
Key Takeaways
- Select the data you want to chart — both the labels and the numbers — before opening the chart tool.
- Google Sheets automatically detects whether your data is organized by rows or columns and builds the chart accordingly.
- The chart appears as an object on your sheet that you can move, resize, or delete without changing the underlying data.
- You can change the chart type, add a title, and adjust axis labels after the chart is created without starting over.
Select your data before opening the chart tool
Click on the first cell of the data you want to chart and drag to the last cell. Include the row or column that holds your category labels — Sheets needs these to label the bars. For example, if you have months in column A and sales numbers in column B, select from A1 to B12. If your labels and numbers are in different rows, select all of them in one rectangle.
You can select non-adjacent cells by holding Ctrl (or Cmd on Mac) and clicking each range, but Sheets works more smoothly when the data forms one continuous block. If your data is scattered, copy it to a new area of the sheet first, then select and chart it from there.
Open the chart tool and let Sheets detect your data layout
With your data selected, click the Insert menu at the top of the sheet, then click Chart. Google Sheets opens the chart editor on the right side of your screen. At the top of the editor, you will see a preview of your chart — Sheets has already made a guess about what you want to show.
Look at the preview. If the bars are grouped the way you expected, move to the next step. If the bars look wrong — for example, if Sheets treated your labels as data or your data as labels — click the Setup tab in the chart editor and check the "Use row 1 as headers" or "Use column A as labels" boxes. These checkboxes tell Sheets which part of your selection holds the category names.
Choose the bar chart type from the chart type list
In the chart editor, click the Chart type dropdown near the top. You will see options including Column Chart (vertical bars), Bar Chart (horizontal bars), and others. Column charts work well for comparing values across time or categories. Bar charts (horizontal) work better when your category names are long.
Click the type you want. The preview updates when ready. If you change your mind, you can switch types again without losing your data or labels — the chart rebuilds itself with the new shape.
Add a title and customize the axis labels
In the chart editor, click the Customize tab. Under "Chart & axis titles," you will see a field for the chart title. Type a name that describes what the chart shows — for example, "Monthly Sales by Region" or "Website Visits Q1 2024." This title appears at the top of the chart on your sheet.
Below the title field, you can add labels for the horizontal and vertical axes. The horizontal axis usually shows your categories (months, regions, products), and the vertical axis shows the numbers (dollars, visitors, units). If Sheets has already labeled these correctly, you can leave them as they are. If you want to change them — for example, to write "Revenue ($)" instead of "Column B" — type the new label in the corresponding field.
Move and resize the chart on your sheet
Once you close the chart editor, the chart appears as an object on your sheet. You can click and drag it to a new location, or grab the corner handles to make it larger or smaller. The chart does not change the data underneath — it is a separate object that references the cells you selected.
If you need to edit the chart later, double-click it to reopen the chart editor. You can change the title, swap the chart type, adjust colors, or modify which data is included. Any changes you make in the editor update the chart when ready on your sheet.
Common reasons a bar graph does not look right
If your chart shows only one bar or has bars in unexpected colors, check whether Sheets is reading your data correctly. Double-click the chart to open the editor, click Setup, and verify that the data range is correct. The range should include all the cells with labels and numbers you want to show.
If some categories are missing from the chart, make sure you selected them when you first opened the chart tool. If you want to add more data after creating the chart, double-click the chart, click Setup, and change the data range to include the new cells. Sheets will rebuild the chart with the updated information.
Frequently Asked Questions
Can I change the colors of the bars after I create the chart?
Yes. Double-click the chart to open the editor, then click the Customize tab. Look for "Series" or "Format" options where you can click on a bar color and choose a new one. You can also change the background color of the entire chart from the same menu.
What if my data has multiple columns of numbers I want to compare?
Select all the columns together — labels plus all the number columns — when you create the chart. Sheets will automatically group the bars so you can compare them side by side. For example, if you have months in column A, sales in column B, and expenses in column C, select A through C and Sheets will show bars for both sales and expenses for each month.
Can I delete a chart without deleting the data underneath?
Yes. Click the chart once to select it, then press Delete. The chart disappears, but your data in the cells remains unchanged. You can create a new chart from the same data anytime.
How do I print just the chart without the rest of the sheet?
Click the chart to select it, then go to File and click Print. Google Sheets will print only the selected chart. If you want to print the chart with some surrounding data, select the chart and the cells together before printing.
What is the difference between a column chart and a bar chart?
A column chart has vertical bars (taller than they are wide), while a bar chart has horizontal bars (wider than they are tall). Use columns for time-based data or when you have many categories. Use horizontal bars when your category names are long and would be hard to read vertically.