How to Make a Bar Graph in Google Sheets: No Fuss 2023 Guide (2023)

While Google Sheets is a spreadsheet tool where data is entered and stored, plain cells are not the most efficient data visualization method.

And that’s where graphs and charts in Google Sheetscome in.

This tutorial will show you how to make a bar graph in Google Sheets(many people also call it a bar chart).

A bar graph is one of the easiest charts to make. But it can be perfect for seeing trends and variations in data over time. You can alwayslearn more about chartsas you go to upgrade your skills.

If you’d like to skip the tutorial and just use a template, you candownload ours here.

So let’s get started!

How to Make a Bar Graph in Google Sheets

The process for making a bar graph in Google Sheets is simple:

1. Select the data
2. Go to Insert > Chart
3. Select the bar graph type in the chart editor
4. Close the chat editor.

That’s It! Making a bar graph in Google Sheets is easy, right?

How to Make a Bar Graph in Google Sheets with Examples

Suppose you have a dataset like the one shown below, and you want to create a bar graph in Google Sheets to view the sales values as the bars:

As this is a dataset, to create a simple bar graph you only need to plot one series on the chart. However, this is still quite useful in day-to-day work, and it allows you to visualize this data quickly.

Let’s get you started creating bar graphs in Google Sheets with the following example:

1. Select the dataset (including the headers)
2. In the toolbar, click on the ‘Insert chart’ icon. Doing so will insert a suggested chart in the worksheet
   

   

3. In the Chart Editor (that automatically shows up in the right), click on the Setup tab, and you will find different chart types. Change the chart type to Bar chart. In case Google Sheets inserts a bar chart by default, you don’t need to do this
   

   

4. You can change the chart’s title by double-clicking on it, which allows you to enter whatever label you want manually.

The above steps would insert a bar graph in your worksheet.

If your data range has 2 columns of data instead of one, then you can use a double bar graph.It will usually appear in the suggestions in the chat editor.

How to Create a Stacked Bar Chart in Google Sheets

In the above example, we learned how to make a bar graph using Google Sheets using a single data set.

But you can also create stacked bar charts for multiple data rangesand in Google Sheets.

Suppose you have a dataset as shown below, and you want to create a stacked bar chart using it:

Below are the steps to learn how to create a bar chart in Google Sheets:

1. Select the dataset (including the headers)
2. In the toolbar, click on the ‘Insert chart’ icon.
3. In the Chart Editor (that automatically shows up in the right), click on the Setup tab, and change the chart type to the Stacked Bar Chart. In case Google Sheets inserts a Stacked bar chart by default, you don’t need to do this step
   

   

4. You can change the chart’s title by double-clicking on it; this allows you to enter whatever title you want manually.

The above steps would give you a stacked bar graph as shown below:

Making a 100% Stacked Bar Graph in Google Sheets

Like the standard stacked bar graph, you can also make a 100% stacked bar chart; Google Sheets allows you to create a chart where all the bars are equal in size, and the value of each series in a bar shows as a percentage.

To insert a 100% stacked bar graph, follow all the steps mentioned above to create a standard stacked bar chart and then make the following changes:

1. Select the already inserted stacked bar chart
2. Click on the three dots at the top right part of the chart, then click on Edit chart.
3. In the Edit chart pane, click on Setup
4. In the Stacking options, select 100%
   

   

The above steps would convert your regular chart to a 100% stacked bar chart (as shown below).

Once you have inserted the bar chart in the worksheet (regular of stacked), you can make some changes to it.

Let’s learn a little about how to customize and format this bar chart.

Customizing the Bar Graph

There are several things you can customize in the bar chart. And these options are available in the Chart editor tab.

To open the Chart Editor tab, click on the chart and click on the three-dotted lines that appear at the top-right of the graph. From the options that appear, click on the Edit Chart.

This will make the Chart Editor show up as a pane on the right.

In the Chart menu, click on Customize option, and it will show you all the choices you have to customize and format the bar graph in Google Sheets.

Let’s quickly go through these options (the best way to learn how to use this would be to give this a try yourself):

• Chart style: This allows you to change the background and border color, and the font style. So in case you need to use Verdana on all your charts, this is where you make those changes. There is also an option to maximize, which will expand the chart to occupy more space
• Chart and axis titles: Here, you can change the chart title, add a chart subtitle, and change the horizontal and vertical axistitles. You can also change the font type, size, and color/style. For example, you can make the font bold if you want.
  

  

• Series: Here, you can edit the series – such as the color of the bar. If you’ve created a stacked bar chart, you can choose the series for which you want to make the changes. An interesting option here is to change the color of a specific bar if you wish. For example, if Product B needs to be highlighted, you can choose a contrasting color (as shown below). You can also adderror barsand data labels using this option.
• Legend: Here, you can change the legend setting, such as the position of the font format. Since we only have one series, having a legend doesn’t make sense. But it would be useful when you have multiple series (examples covered later in this tutorial)
• Horizontal Axis: Here, you can change the horizontal axis label font type, size, and format. You can also specify the maximum and minimum values of the chart (by default, the bar graph adjusts the maximum values based on the dataset).
• Vertical Axis: Here, you can change the vertical axis label font type, size, and format. You can also reverse the axis (which means that Product E will be shown at the top and Product A at the bottom)
• Gridlines: You can specify the color of major and minor gridlines or turn these off. I prefer not to have gridlinesat all.

Another important chart that many people prefer is the column chart, which is just like a bar chart but has vertical columns instead of horizontal bars.

So this is how you can make a bar graph in Google Sheets and then customize it accordingly.

I hope you found this tutorial useful!

How to Create a Bar Graph in Google Sheets With A Template

Can’t be bothered learning how to create the bar graph in Google Sheets? We have you covered. Click on the following link to a basic Google Sheets bar graph template. There are four templates to use in this spreadsheet, so you just have to navigate between the sheets at the bottom of the page.

You will also need to make a copy to edit the spreadsheet. To do this, open the file menu, then click make a copy.

An editable copy will open in a new tab.

How to Label a Bar Graph in Google Sheets

You can customize your Google Sheet bar graph in the chart editor even after you have already created it. You can also add or change the labels. To do this:

1. Go to the chart editor either by double-clicking your chart or clicking the three dots in the chart and choosing edit chart
2. Go to Customize> Chart and Axis titles

3. If you click on Chart titledrop down menu for which title you want to add or edit.

4. Choose one, for example, horizontal axis and type in your label in the title text bar.

Your labels will be added to your chart immediately. You can also change the individual labels for each bar in each axis.

However, you can do this in the chart editor. To change the labels for the bars you have to change them in your data table. For example, in our chart, if you want to change Product A to Apple we can type it in the data table and it will automatically change in the bar graph.

How to Add Error Bars to a Bar Chart in Google Sheets

Error bars are used to represent estiimations in a graph. Here’s how to add error bars,

1. Go to the chart editor. If you closed it previously, you can reopen it by double clicking on the chart.
2. Go to Customize

3. Click the dropdown for Series

4. Check the box forError bars

5. Input the percentage of error. You can also change the type of value to constant, standard deviation or none.

You will see the error bars added to your chart like below:

How to Format a Data Point

If you want to format one particular data point to stand out in your bar graph, here’s how you do it:

1. Double click on the graph to open up the editor
2. Navigate to Customize > Series
3. Click the Addbutton next to Format data point
   
   

   

4. Select the data point you wish to change the formatting of and click OK
5. Change the color to your desired one

How To Make A Bar Graph on Google Sheets FAQs

Can You Make a Bar Graph on Google Sheets?

Yes, you can make a bar graph in Google Sheets by following these steps:

1. Highlight the data you wish to turn into a bar graph
2. Navigate to Insert > Chart
3. In the Setupmenu for the chart, select the Bar chartoption in the drop-down list under the Chart typemenu.

How Do I Make a Simple Bar Graph in Google Sheets?

1. Highlight the data
2. Navigate to Insert > Chart
3. Head to Setup > Chart Type > Bar chart

How Do You Make a Bar Graph With Two Sets of Data in Google Sheets?

For a double bar graph, you need both sets of data to be able to be plotted along one axis. So, you just need to have the two sets of data in adjacent columns with a third column being data points that the other two can relate two. Then you just have to follow the normal steps to making a bar graph.

What’s the Difference Between a Column Graph and Bar Graph in Google Sheets?

Bar graphs and column graphs are very similar and are both great ways to show information in a digestible way. The primary difference between the two is the axis that the data flows. Bar graphs run from left to right, while column graphs show the data from bottom to top. You can switch either of these charts by changing the x and y axes.

If you also want to add a line to your graph, you should do a column graph instead of a bar graph.

Once I Create a Bar Graph, How Do I Change the Titles, Legends, Series, Etc.?

You can make all of these changes through the chart editor tab.

1. Double click on the chart.
2. Click on the customize tab.

From here, you can choose what you’d like to edit. There is a more detailed explanation above of what each section does under the title Customizing the Bar Graph.

Summing Up

So, that’s how to make a bar graph in Google Sheets. If you’re interested in learning more about charts and graphs, check out how to create combo charts in Google Sheets.

Related:

• • Save Chart as Image in Google Sheets
  • How to Make a Line Graph in Google Sheets
  • How to Make a Histogram in Google Sheets
  • How to Make a Scatter Plot In Google Sheets
  • How to Create a Pie Chart in Google Sheets
  • Gantt Chart in Google Sheets