TechJunkie is a BOX20 Media Company

Home Web Google Sheets How to Make a Graph in Google Sheets

How to Make a Graph in Google Sheets

How to Make a Graph in Google Sheets

Knowing how to utilize all of the tools that Google Sheets gives you access to is essential. Working with a vast dataset doesn’t just require typing in every number you have into a spreadsheet file. You’ll need to illustrate data in graphs as well. While inserting Roman numerals in Google Sheets is easy; the same cannot be said for making graphs, especially if you are a beginner. However, the process is still reasonably easy to learn.

How to Make a Graph in Google Sheets

Graphs can help you organize your data in a form that’s easier to digest for everyone else. Aside from that, they have the added benefit of making your spreadsheet look more presentable. Google Sheets has built-in features for making graphs, making the process much easier.

  1. Open the spreadsheet in Google Sheets.
  2. Highlight the cells you want to illustrate.
  3. Click Insert and select Chart.
    Chart button in Google Sheets
  4. Customize your chart using the options on the right.
    Chart Editor in Google Sheets

The chart editor will let you change labels, values, colors, and style. It’s also worth noting that you don’t need to highlight cells with data to create a chart. You can create one from scratch by clicking on an empty cell and then using the Chart feature.

For better visualization, you can alternate the row or column colors in Google Sheets.

How to Make a Bar Graph in Google Sheets

To make a bar graph in Google Sheets, you must first follow the steps above. Once done, click Chart type under Chart editor; scroll down until you see the different bar graph templates that Google Sheets has.

Google Sheets chart editor bar graphs

Bar graphs are best for comparing the change in data over some time. 

How to Make a Graph in Google Sheets From Android or iPhone

If you’re on the road and don’t have your laptop to make a quick graph, the Google Sheets app can still help you out. To create a graph using the app on your phone, follow these steps.

  1. Open your spreadsheet.
  2. Highlight the cells with the data you want to turn into a graph.
  3. Tap the plus icon.
    Google Sheets Mobile app tapping plus icon
  4. Select Chart.
  5. Adjust and customize your chart using the chart editor.
    Google Sheets Mobile Chart Editor
  6. Tap the check icon at the top left once you’re done.

If you want to change chart types, tap on Type, and you’ll see a selection of recommended charts and templates for other types.
Google Sheets mobile chart types

Illustrate Data With Graphs!

Graphs are going to be beneficial for you, as well as for those who are looking at your spreadsheet. It’s one of the best ways to simplify complex data that would otherwise look crowded when placed on cells. If you don’t want others messing with the data while creating charts, make sure to lock the rows and cells in Google Sheets.


Q: Can I transfer my Google Sheets Graphs to Google Docs?

A: Yes, you can copy the chart and paste it to any Google Docs you own. You can paste it linked or unlinked to the original spreadsheet. Only those with access to the Google Sheet can edit the chart when linked.

Q: How to make graphs in Google Docs?

A: You can make a graph in Google Sheets, copy it, and then paste it on your doc file. Alternatively, you can click Insert and add a chart from there.

Q: How many charts can I add to Google Sheets?

A: You can add as many charts as possible on a single spreadsheet. You can even create multiple charts for a single data set.

How to Disable Google Chrome's New Material You Design

Read Next 

Leave a Reply

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

Jonas Sunico

Nov 18, 2023

Jonas is a writer with over 6 years of experience in the tech and gaming industry. He holds a bachelor's degree in Journalism from University of the East Philippines and is one of the proud leaders of the academe's Journalism Society. At heart, he's a hardcore tech junkie that loves video games, the latest gadgets, and the wonderful science behind social media and AI.

314 Articles Published