+

Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

Close
HomeQuizzoneWhatsappShare Flash Reads
 

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

Jan 7, 2021, 01:17 IST
Business Insider
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.

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.

You can customize your graph using the menu on the right-hand side.Devon Delfino/Business Insider

Related coverage from Tech Reference:

You are subscribed to notifications!
Looks like you've blocked notifications!
Next Article