In this article:

How to Create a Bar Chart in Google Sheets

Unsure which chart type to use? Click here to find the right chart for your data and the ideas that you want to convey.

Bar charts consist of rectangles representing the values of different items or even the value of a metric over time. Bar charts are best used for comparison of the values of a certain metric over different items. 

Google Sheets offers three types of bar charts: the simple bar chart, the stacked bar chart, and the 100% stacked bar chart. This tutorial is a straightforward guide on how to insert a bar chart in Google Sheets with some notes on the type of data that it requires. 

How to format your data for a bar chart 

The data for a simple bar chart needs to have the following columns:

  • First column: the label for each bar
  • Second column: the height (value) of each bar

Each data row corresponds to a bar in a bar chart. 

For stacked bar charts, you need to have the following data columns:

  • First column: bar labels
  • Each succeeding column represents a bar in the chart, with each value for each row denoting the contribution of the row to the total bar

You can have grouped bars in a bar chart as well, by using the following scheme:

  • First column: individual bar labels
  • Each succeeding column represents a grouping of bars, and the last row of each column contains the total from that column

As you can see, this has the same data format as for the stacked bar charts. To get a grouped bar chart, select Bar chart as the chart type. 

How to create a bar chart

Here are the steps in creating a bar chart from an existing dataset in Google Sheets:

Step 1: Select the range of data that you want to visualize.

Spreadsheet data
The dataset to be visualized, selected

Step 2: Click Insert, then click Chart.

Insert Chart
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not a bar chart by default. On the right side, the Chart editor sidebar is loaded. Click the drop-down box below the Chart type. A list of possible chart types will be loaded. Look for the Bar chart option and click it. 

Chart type editor
Chart editor, Setup tab, Chart type, Bar chart selected

Step 4: We now have a bar chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles

Customize Chart
Chart editor, Customize tab. Chart & axis titles option highlighted.

Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. In the text box below the drop-down box, type the title of the chart. 

Chart titles options
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.

Step 6: Here are some options in modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from size 10 to 36 or specify a value beyond the given options. You can also choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format, then click the Alignment option. Click the Center option. 

We now have the following chart!

Final Chart
Bar chart with title and axis labels

Check out our chart guide to learn how to add the title or axis labels, as well as how to change the colors.

How to create a stacked bar chart

Unlike the typical bar chart which we had in the previous section, a stacked bar chart also visualizes the components of a certain quantity, thus adding another dimension to your bar chart. This means that the dataset should have multiple columns. 

Before you follow the steps, make sure that your data also contains the breakdown of the values of the components.

Step 1: Select the range of data that you want to visualize.

Spreadsheet data
The dataset to be visualized, selected

Step 2: Click Insert, then click Chart.

Insert chart options
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not a bar chart by default. On the right side, the Chart editor sidebar is loaded. Click the drop-down box below the Chart type. A list of possible chart types will be loaded. Look for the Stacked bar chart option and click it. 

Chart type options
Chart editor, Setup tab, Chart type, Stacked bar chart selected

Step 4: We now have a bar chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles

Customization options
Chart editor, Customize tab. Chart & axis titles option highlighted.

Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. In the text box below the drop-down box, type the title of the chart. 

chart and axis titles
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.

Step 6: Here are some options for modifying the title of the chart: 

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range from 10 to 36 or specify a value beyond the given options. You can also choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Then click the Center option. 

We now have the following chart!

Final Chart
Stacked bar chart with title and axis labels

Check out our chart guide to learn how to add the title, axis labels, or change the colors.

How to create a 100% stacked bar chart

Sometimes you are not interested with the total quantity but with the differences in the composition of certain quantities, either over time or among different items. For this, a 100% stacked bar chart is sufficient. A 100% stacked bar chart only differs from a stacked bar chart visually: the stacked bars are of the same length. This highlights the differences in the composition of each stacked bar. 

Step 1: Select the range of data that you want to visualize.

Spreadsheet data
The dataset to be visualized, selected

Step 2: Click Insert, then click Chart.

Insert chart option
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not a bar chart by default. On the right side, the Chart editor sidebar is loaded. Click the drop-down box below the Chart type. A list of possible chart types will be loaded. Look for the 100% stacked bar chart, and click it. 

Chart type options
Chart editor, Setup tab, Chart type, 100% stacked bar chart selected

Step 4: We now have a bar chart. To add title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles

Customize tab
Chart editor, Customize tab. Chart & axis titles option highlighted.

Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. In the text box below the drop-down box, type the title of the chart. 

chart and axis titles
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.

Step 6: Here are some options in modifying the title of the chart: 

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can specify a value beyond the given options. You can also choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format, then click the Alignment option. Click the Center option. 

We now have the following chart!

Final Chart
100% stacked bar chart with title and axis labels

Check out our chart guide to learn how to add the title, axis labels, or change the colors.

How to create a grouped bar chart

There is a “hidden” type of bar chart in Google Sheets, which is the grouped bar chart. This is not explicitly listed under the Chart type option in the Chart editor

Unlike a typical bar chart which we had in the previous section, a grouped bar chart groups together different but similar or related bars. This allows you to also make comparisons within these groups besides simply comparing the bars. 

Before you follow the steps, make sure that your data also contains the breakdown of the values of the bars that you want to group together. 

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected

Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not a bar chart by default. On the right side, the Chart editor sidebar is loaded. Click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for the Bar chart option and click it.

Chart type selector
Chart editor, Setup tab, Chart type, Bar chart selected

Step 4: We now have a grouped bar chart. To add a title to the chart, go to the Customize tab in the Chart editor and click Chart axis & titles

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.

Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.

Step 6: Here are some options for modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Then click the Center option.

We now have the following chart!

Grouped bar chart with chart title and axes labels.
Grouped bar chart with chart title and axes labels. 

How to switch the arrangement of the bars in the bar chart 

As you can see, the years listed on the y-axis are listed with the earliest on the top down to the latest on the bottom. You can easily reverse that order. In the Chart editor sidebar, click Customize, then look down to find Vertical axis options. Click it. You will find the Reverse axis order checkbox. Tick it.

Chart editor, Customize tab, Vertical axis options, Reverse axis order ticked.
Chart editor, Customize tab, Vertical axis options, Reverse axis order ticked. 

Here is the resulting bar chart:

Same stacked bar chart as in previous section, but the order of the bars reversed.
Same stacked bar chart as in previous section, but the order of the bars reversed.

The growth of the annual sales can be easily seen in this order. 

A sample sheet to check

If you got a bit lost, or just want to check if you are doing it right, here is a sample sheet that you can open to see how they work:

Bar Chart Sample Sheet

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started