Wednesday, 20 November 2019

How to Make a Graph in Google Sheets

The Google Sheets logo

A data-heavy spreadsheet can be difficult to read through and process. If you’re using Google Sheets, adding graphs to your spreadsheet can help you present this information differently for easier reading. Here’s how you can add graphs to your spreadsheet.

Before we begin, you should be aware of a slight difference in terminology. Like Microsoft Excel, Google Sheets refers to all types of graphs as charts. You can use the Chart Editor tool to create these graphs and charts in Google Sheets.

Insert a Chart into Google Sheets

You can create several different types of graphs and charts in Google Sheets, from the most basic line and bar charts for Google Sheets beginners to use, to more complex candlestick and radar charts for more advanced work.

RELATED: The Beginner's Guide to Google Sheets

To start, open your Google Sheets spreadsheet and select the data you want to use to create your chart. Click Insert > Chart to create your chart and open the Chart Editor tool.

In Google Sheets, click Insert > Chart to insert a chart

By default, a basic line chart is created using your data, with the Chart Editor tool opening on the right to allow you to customize it further.

A created chart in Google Sheets

Change Chart Type Using the Chart Editor Tool

Read the remaining 24 paragraphs



from How-To Geek https://ift.tt/331gr3z

No comments:

Post a Comment