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

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 Sheets come 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 always learn more about charts as you go to upgrade your skills.

If you’d like to skip the tutorial and just use a template, you can download 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:

Dataset to make a bar graph in Google Sheets

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
    Click on the Insert Chart icon
  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
    Select the bar chart option in the chart editor

     

  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.

Sales Data by Product

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 ranges and in Google Sheets.

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

Data for stacked bar chart

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
    Select Stacked bar chart option in Chart editor
  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:

Standard Stacked bar chart

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%
    Change stacking to 100% to get 100% stacked bar chart

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

100% Stacked bar chart

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 axis titles. You can also change the font type, size, and color/style. For example, you can make the font bold if you want.
    Chart Axis and Titles editing
  • 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 add error bars and 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 gridlines at 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.

Examples of the Charts

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
Go to Customize > Chart and Axis titles
  1. If you click on Chart title drop down menu for which title you want to add or edit.
If you click on Chart title drop down menu for which title you want to add or edit
  1. 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.

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
Go to Customize
  1. Click the dropdown for Series
Click the dropdown for series
  1. Check the box for Error bars
Check the box for error bars
  1. Input the percentage of error. You can also change the type of value to constant, standard deviation or none.
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:

bar graph with error bars added

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 Add button next to Format data point

    Format a data point in Google Sheets
  4. Select the data point you wish to change the formatting of and click OK
  5. Change the color to your desired one
Change color of a data point
A formatted single data point

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 Setup menu for the chart, select the Bar chart option in the drop-down list under the Chart type menu.

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:

Most Popular Posts

Sumit

Sumit

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.

5 thoughts on “How to Make a Bar Graph in Google Sheets: No Fuss 2023 Guide”

  1. Is there a way to have the numerical value inside the bar of the bar graph ? (That way when two data points are very close you can easily see which is greater)

    Reply
    • Yes!
      1. Double-click the chart you want to show values in.
      2. Click Customize and then Series.
      3. Check the box next to “Data labels.”

      Reply
  2. I just need a help.. I am trying to import an excel sheet(1 sheet with timeline graphs) but it is not showing the same S on the excel sheet.

    What must be gone wrong? Can you help?

    Best,
    Risa

    Reply

Leave a Comment