Automatically Generate Charts in Google Sheets - - Windows Tips and Tricks with Geek

Thursday, November 18, 2021

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.

Open a 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.”

Insert a 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.

Select Chart Type

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.”

Select the Data Range to Populate the Chart

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

Chart has Been Inserted Into Spreadsheet

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.

Automatically Updated Chart

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.”

Click Setup Tab

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

Choose a Different Chart Type

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.

Click Customise Tab to Customise Your Chart

That’s all there is to it.

No comments:

Post a Comment