Skip to content

How to create a bar graph in Google Sheets?

  • by
  • 3 min read

Google Sheets is a cloud-based spreadsheet program by Google, it lets its users create and edit spreadsheets directly on the web browser without the requirement of any special software. It is a part of the web-based free Google Docs Editors suite.

One of the best features of Google Sheets is that multiple users can work on the same spreadsheet at the same time and it also allows its users to share the spreadsheets with others and also manage the access each user has to the document.

Bar graphs are really important when you are trying to make your work more organised and easier to understand.

In this guide, we have discussed how to create a bar graph in Google Sheets to help you create a bar graph in a few simple steps.

Also read: How to merge cells in Google Sheets?

Creating a bar graph in Google Sheets

If you want to know how to create a bar graph in your spreadsheet on Google Sheets then follow the steps below.

Step 1: Open your spreadsheets on Google Sheets or create a new one and enter your data in it.

Step 2: Select the data you want to add to the bar graph by clicking and dragging the mouse over the cells.

Step 3: Click on the Insert tab and then in the dropdown menu that appeared click on the Chart option. Once you click on the Chart option, it will automatically create a chart suitable for the content.

Step 4: In the Chart Editor menu located on the right side of the screen, click on the dropdown menu under Chart Type and then from the dropdown menu select the type of bar chart you want for your data.

Your bar graph will be created and you can also customize the bar chart in the manner you see fit for your data. You can aggregate your data, adjust the colours of the bars and the background of the chart, change the chart and axis titles and do many more things with the bar graph to make it more organised and better looking.

Also read: How to create a drop-down list in Google Sheets?


Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: [email protected]