Google Sheets gives you a variety of options for your graph, so if you want to show parts that make up a whole you can go for a pie chart, and if you want to compare statistics, a bar graph will likely make more sense. Here are our step-by-step instructions for making a graph in Google Sheets.

  1. Select cells. If you’re going to make a bar graph like we are here, include a column of names and values and a title to the values. 

Best Chromebooks available nowBest Ultrabooks available now

2. Click Insert. 3. Select Chart. 4. Select which kind of chart. Pie charts are best for when all of the data adds up to 100 percent, whereas histograms work best for data compared over time. 5. Click Chart Types for options including switching what appears in the rows and columns or other kinds of graphs. 6. Click Customization for additional formatting options. 7. Click Insert. You’ve inserted a graph into your spreadsheet.

Google Sheets tips

Previous TipNext Tip

Use Google Sheets offlineHow to use Google Sheets conditional formattingOpen Google Sheets in ExcelCreate filters in Google SheetsHere’s every Google Sheets keyboard shortcutWrap text in Google SheetsConvert Excel spreadsheets to Google Sheets How to make a graph or chart in Google Sheets - 43How to make a graph or chart in Google Sheets - 65How to make a graph or chart in Google Sheets - 91How to make a graph or chart in Google Sheets - 90How to make a graph or chart in Google Sheets - 99How to make a graph or chart in Google Sheets - 59