Automatically Generate Charts in Google Sheets

 

Google Sheets lets you generate charts automatically to create a visually appealing way to convey information. Using charts is a great way to help people retain data a lot easier than looking at a bunch of numbers.

Google Sheets gives you a wide variety of free graphs from which to choose. Whether you want to use a pie chart or something a little more complicated like a radar chart, you won’t be disappointed with the options available.

The first thing you need to do is fire up your Google Sheets homepage and open a new or existing spreadsheet.

If you just opened a new spreadsheet, now would be a good time to insert some data into the cells. After that, click “Insert” and then “Chart.”

From the drop-down list, click the type of chart you want to add. In this example, we are going to use a smooth line chart, but you can choose from 30 different types of charts.

Now, you have to choose which cells you want to appear on the table. You can manually enter the range, or click and drag your pointer to select the desired data range. Click the grid icon to enable manual selection.

After you’ve entered or selected the range of data, click “OK.”

After, your chart populates with all the data included from the range of rows you selected.

Note: Because of the way Google handles charts and tables across platforms, make sure all parts of the chart are visible if you plan on inserting them into a Google Docs or Slides project. Google saves each chart as an image, then inserts it into your document. If you try to resize it from Docs, your chart could end up looking blurred or deformed.

Any adjustments you make to your data are automatically updated and change the way your chart appears, without having to re-insert anything or refresh the page.

Google Sheets also lets you change the type of chart without having to re-insert anything either. Just double click the chart to bring up the Chart Editor menu and then click “Setup.”

From the “Chart Type” dropdown menu, select a different style and all your data is transformed into a new fully customizable chart style.

When you click the “Customize” tab at the top of the chart editor, a list of fully customizable options reveals itself. Clicking any of the options lets you delve in and change colors, font, legends, and so much more.

That’s all there is to it.