How To Make A Chart In Google Sheets [Bar Graph, Pie Chart]

As an Amazon Associate and affiliate of other programs, I earn from qualifying purchases.

Adding a pie chart or bar graph to your content makes it more interesting and authoritative at the same time. However, most people still think that creating a graph is a tough task and needs some serious mathematics skills.

On the contrary, creating graphs is very easy and anyone who knows how to use the internet can do it. Yes, you can create awesome bar graphs and pie charts using various online tools.

However, in this tutorial, we teach you to create graphs in Google Sheets because it’s easy and free. So, without wasting any time lets dive into the tutorial.

How To Make A Chart In Google Sheets

Before we start, make sure you are ready with all the data that you want to put into the chart. Now once you have the data follow these steps to create charts in Google Sheets

Create a Chart

1. On your browser visit Google Sheets. Now add a new Blank sheet to create a graph and rename the sheet if you want.

Google sheets

2. Next, add the data with their respective value as shown in the screenshot below.

data in google sheets

3. Now select/highlight all the data in the sheet and click on the insert chart icon on the top right corner.

select the chart

4. Now as you do that, you will see a chart pops up on the screen with all the relevant data.

Pie Chart in Google Sheets

5. If you are happy with the chart then you download it in PNG, PDF, and SVG format and use it. Click on the three dots icon on the top right of the chart to access the download option

Download the chart

However, if you want to change the chart type to some other formats then keep reading this tutorial.

ALSO READ: How To Check Word Count In Google Sheets OR Docs

Change The Chart Type

1. On the right-hand side under the Chart editor tab, select the chart type box

Chart editor box

2. Now you can select your desired chart type. Google Sheets have various chart formats, from pie chart and bar graphs to line, area and others.

Select chart type

3. Once you find your desired chart, select it and the main chart on the screen shall change accordingly.

Selected chart

Now you can either download this chart or you can further customize it.

Customize The Chart

If you want to make the chart more personalized then you can do that by customizing it and for that, you can follow these steps.

1. On the chart click on Edit chart. The chart editor will open on the right side, now select Customize.

Customize the chart

2. Under customize settings you get various options like Chart style, Chart & axis titles, Series, Legends and much more.

customize options

Note: The customization options are different for different chart types.

3. To change the font style or chart’s foreground and background color you can select the chart style option. You can also change the chart layout from 2D to 3D using this option.

Chart style

4. Similarly, if you want to add a title to the chart then you can do that by selecting the option Chart & axis titles. Here you can give your chart a title or a subtitle. Also, you can add a title to the X and Y-axis from here.

Adding title to the chart

Now similarly, you can use all the options under the customize settings and make the chart more personalized. If you still face any problem while creating and customizing charts on Google Sheets then you can read this tutorial for help.


With this, we have come to the end of this article. We hope we help you out in creating charts in Google sheets. Also as you saw it is very easy to make charts in Google Sheets, you just need to fill the data and leave everything to Google sheets.

Moreover, you can create a different type of charts in it that meets all your requirements. In the end, we will just like to say that Google Sheets is an awesome free tool to create charts online and anyone can use it.

Photo of author

Ankit Prasad

Ankit is a tech enthusiast and loves to write. He is also very keen on gadgets and smartphones. Likes to read tech blogs and gain as much knowledge as he can.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.