How to Make a Graph in Google Sheets

Sometimes the data that you are creating in a spreadsheet is better understood if you can create a visual representation of that data. This is often best achieved by making a graph so, if you are working on a spreadsheet, you may find yourself wondering how to make a graph in Google Sheets.

Fortunately this is something that you can generate with just a few steps. Once the graph has been created you will have a number of different options for customizing the way your data is displayed. So continue below to find out how to make a graph in Google Sheets.

 

How to Create a Graph in Google Sheets

The steps in this article were performed in the desktop version of Google Chrome, but will also work in other modern Web browsers like Firefox and Microsoft Edge. This guide will assume that you already have a spreadsheet containing data that you want to put into a graph, but you can also create a new spreadsheet and add the data for the graph as well.

Tools you will need:

  • Computer with Internet connection
  • Modern Web browser like Chrome, Firefox, or Edge
  • Google Account
  • Google Sheets file with data for graph

 

Step 1: Go to your Google Drive at https://drive.google.com. If you aren’t already signed into your Google Account you will be prompted to do so.

 

Step 2: Open the Google Sheets file containing the data you want to graph, or create a new spreadsheet file.

 

Step 3: Select the cells containing the data that you want to put on the graph. Note that you will want to have a header row in row 1 that contains the names that you want to use for the x and y axis of the graph. In the image below that would be “Month” and “Number of Sales.”

google sheets graphs and charts

 

 

Step 4: Click the Insert tab at the top of the window.

how to create a graph in google sheets

 

 

Step 5: Choose the Chart option.

how to create a chart in google sheets

 

 

Step 6: Find the Chart editor column at the right side of the window, where you will see a number of different options for customizing the appearance and layout of your graph. There should also be a graph on the spreadsheet displaying your graphed data using the current settings in the Chart editor column.

how to make a graph in google sheets

 

 

Step 7: Adjust the settings in the Chart editor to get the graph appearance that you need for your work.

how to make a chart in google sheets

 

 

The options in the Chart editor on the Data tab are:

  • Chart type – Select the type of graph for your data. There are a ton of options on this menu, so you can experiment with them until you find the one that works best for you.
  • Stacking – This option will let you display “stacked” data in your graph, but requires multiple columns and a specific format. You can read this article on Google’s support site for additional information on stacked charts.
  • Data range – This setting defines the range of cells in your spreadsheet that are comprising the data display for the graph. You can change this if you want to use a different range of cells.
  • X-axis – You can modify this to change the data that is being used to determine the x axis of the graph.
  • Series – You can modify this to change the data that is being used for the y axis of the graph.
  • Switch rows/columns – Turn your rows into columns and vice versa for the graph layout, which will affect the way that the graph data is displayed.
  • Use row x as headers – Select this if your data contains headers that you want to use to label the axes of your graph.
  • Use column x as labels – Select this to use the data in the specified column as labels for your data.
  • Aggregate column x – This lets you aggregate the data in the specifiedcolumn. Note that this may not change anything depending on the type of data in that column.

There are additional options available if you click the Customize tab in the Chart Editor. These options include:

  • Chart style
  • Chart & axis titles
  • Series
  • Legend
  • Horizontal axis
  • Vertical axis
  • Gridlines

 

Additional Notes

  • If you update the data in the cells that are populating the graph, then the graph will update automatically.
  • While Google Sheets will save itself automatically when you make changes, this doesn’t happen if you lose your Internet connection. So make sure that you see a “Saved” note at the top of the page if you have done a lot of work that you don’t want to risk losing because you don’t have an Internet connection.
  • If you click back into the spreadsheet, the Chart editor column will disappear. You can reopen the Chart editor by clicking the three dots at the top-right of the graph, then choosing the Edit data option.

 

Would you rather work on your spreadsheet in Excel than Google Sheets? Find out how to export a Google Sheets file for Microsoft Excel by downloading a copy of the file in the .xlsx file format.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.