Making Bar-Graphs in Google Sheets

Bar Graphs show you varying data and stats across multiple variables. I will show you how to make one for any Google Sheets data table in just a few steps.

Also, keep in mind that there is a difference between Bar Graphs and Histograms.

Step #1: Establish Axes

Making Bar-Graphs in Google Sheets Step 2

You will need a data table with at least two columns: one to set the x-axis, and one to set the y axis. 

The X-Axis will typically be some sort of variable counter, whether it is a trial number or some time frame. in this case, the x-axis will be the 12 months of the year. 

The Y-axis will be some numerical value associated with the parallel Y-Axis Cell. In this case, it is some random number between 1 and 6. 

Step #2: Insert Chart

Making Bar-Graphs in Google Sheets Step 2

Next, highlight your entire data table and click Insert on the toolkit located in the header. Then, in the drop-down menu, select the Chart option. That will insert a line graph with the data from your table ported and automatically filled into chart form.

Step #3: Pick Bar-Graph

Making Bar-Graphs in Google Sheets Step 3

In the chart editor menu, you will see an option to select the Chart Type.  This will open a massive catalogue of different charts that you can create.

As you scroll down, you will see the Bar option. Select that, and it will transform your line graph into a Bar Graph. 

Step #4: Customize

Making Bar-Graphs in Google Sheets Step 4

In the chart editor, you will also see the Customize menu. This will let you edit and correct your scatterplot until you get what you want out of it.


And there you have it, that is how you create a Bar Graph in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!