How to create a chart or graph in Google Sheets to get a visual display of your data

Advertisement
How to create a chart or graph in Google Sheets to get a visual display of your data
Select "Chart" from the drop-down menu.Devon Delfino/Business Insider
  • You can easily create a graph in Google Sheets to get a visual display of your data.
  • Once added, you can further customize the chart or graph so that it displays the information in the most comprehensible way.
  • Here's how to use Google Sheets to create a graph to accompany your spreadsheet.

Spreadsheets can be extremely useful tools in themselves, but at a certain point, all that data can just be too much to process.

Advertisement

That's when a chart or graph can help clarify things. If you use Google Sheets, you can easily add a chart to your existing spreadsheet in just a few simple steps.

Here's what you need to know to get it done.

Complimentary Tech Event
Transform talent with learning that works
Capability development is critical for businesses who want to push the envelope of innovation.Discover how business leaders are strategizing around building talent capabilities and empowering employee transformation.Know More

How to create a graph in Google Sheets

Creating a graph in Google Sheets is fairly simple as long as you're logged into your Google account.

1. Open your Google Sheet, or create a new one by going to sheets.new and inputting your data into a sheet.

Advertisement

2. Select the cells you want to use in your chart by clicking the first cell and holding shift on your Mac or PC keyboard while selecting the other cells you want to include.

3. In the top toolbar, select "Insert" and then "Chart."

4. Your chart or graph will then appear over your spreadsheet. Google Sheets will select whichever chart it deems as the best option for your data. However, you can always change the kind of chart or graph used by clicking the drop-down menu in the chart editor, located on the right-hand side of the screen.

How to create a chart or graph in Google Sheets to get a visual display of your data
You can customize your graph using the menu on the right-hand side.Devon Delfino/Business Insider

Related coverage from Tech Reference:

{{}}