How to make a bar graph in Google Sheets
Learn how to turn spreadsheet data into a clear bar graph in Google Sheets, from selecting your data to customizing colors and labels.
Quick answer
Select your data range including headers, then click Insert in the menu bar and choose Chart. Google Sheets will auto-generate a chart—use the Chart editor's Setup tab to change the chart type to Bar chart, then customize colors, titles, and axis labels under the Customize tab before closing the editor.
Steps at a glance
- Enter labels in the first column and numeric data in other columns
- Select the entire data range including headers
- Click Insert, then choose Chart from the menu
- Open the Setup tab and set Chart type to Bar chart
- Use the Customize tab to edit titles, colors, and legend
- Resize or reposition the chart on your sheet
Summary
A bar graph in Google Sheets turns rows of numbers into horizontal bars that make comparisons easy to see at a glance. It's built using the same Chart tool that powers every chart type in Sheets, so once you know the layout rules, you can switch chart types in seconds.
Step-by-step guide
Step 1
Set up your data correctly
Put a label for each item you're comparing in the first column—these become the bars on your vertical axis. Enter the numeric values in the columns to the right, with one column per data series. If your data is scattered across a large sheet, it helps to sort-a-table first so related rows sit together before charting.
Step 2
Select the data range
Click and drag to highlight all the cells you want in the chart, including the header row and row labels. Google Sheets uses these headers to automatically label your legend and axes, so don't skip them even if they're just text.
Step 3
Insert the chart
With your range still selected, click Insert in the top menu bar, then choose Chart. Sheets analyzes your data and inserts a chart onto the sheet immediately, opening the Chart editor panel on the right side of the screen at the same time.
Step 4
Change the chart type to Bar
In the Chart editor, click the Setup tab and look at the Chart type dropdown near the top. Click it and select Bar chart from the list—you'll see the preview update instantly. If the bars run the wrong direction, this same panel is where you fix it, since a related walkthrough on how to create-a-chart covers switching rows and columns in more detail.
Step 5
Customize titles, colors, and legend
Click the Customize tab in the Chart editor to access formatting options. Under Chart & axis titles, add a descriptive title and axis labels. Under Series, you can change bar colors individually, and under Legend, you can move or resize the legend key so it doesn't overlap your data.
Step 6
Resize and place the chart
Click outside the Chart editor to close it, then drag the chart's corner handles to resize it or drag its body to reposition it on the sheet. You can also click the three-dot menu on the chart and choose Move to own sheet if you want the graph on a dedicated tab, similar to how you'd organize data after you add-a-new-sheet for a fresh project.
Why this matters
You're staring at a spreadsheet full of sales figures, survey results, or budget numbers and need to present them in a meeting where nobody wants to read raw cells. A bar graph turns that data into a visual that people understand in seconds, and it takes less than a minute to build.
Frequently asked questions
What's the difference between a bar chart and a column chart in Google Sheets?
A bar chart displays horizontal bars with categories on the vertical axis, while a column chart displays vertical bars with categories on the horizontal axis. Both use the same data setup—you switch between them using the Chart type dropdown in the Setup tab.
Can I compare multiple data series in one bar graph?
Yes. Add each additional series as its own column next to your first data column before selecting the range. Google Sheets will automatically group the bars by category and color-code each series in the legend.
Can I make a bar graph without a paid Google account?
Yes, the Chart tool including bar charts is fully available on a free Google account with Google Sheets. No add-ons or upgrades are required to create, customize, or download this type of chart.
How do I change the color of just one bar?
In the Chart editor, click the Customize tab, then open the Series section. Select the specific data point from the dropdown and choose a new color—this overrides the color for just that bar without affecting the rest of the series.
Create interactive demos like this one — free, no coding required.
Start for free →