Skip to content

Create a Chart in Google Sheets

In this article, you will learn how to create a chart in Google Sheets.

It’s not as complicated as you may first imagine. Just follow the steps below.

  • Set up the data
  • Select the data
  • Go to Insert > Chart
  • Change the chart type if necessary

We will break down each of these steps in greater detail below.

Set Up the Data

Before you can create a chart in Google Sheets, you need the data that will populate the chart. If there is no data, there can be no chart.

Of course, each chart will have its own data requirements, so it is important to understand the different types of charts and what they are used for.

To learn more about the different types of charts you can create within a spreadsheet, check out our article, Spreadsheet Graphs.

Once you have the data set up and ready to go, you are ready for the next step.

Select the Data

This step is simple, but it is also not to be missed.

It is certainly possible to create a chart in Google Sheets without first selecting the data; however, it is much easier to create a chart by selecting the data from the start.

Go to Insert > Chart

Using the Google Sheets Menu, click on the Insert tab, and then click on Chart.

Change the Chart Type if Necessary

Once you click on Chart, Google Sheets will try and guess what type of chart you are creating and will create it.

If Google Sheets does not create the chart you are after, you can change the chart by using the Chart Editor panel on the right side of your Google Sheets application.

If you do not see the Chart Editor panel, click on the chart, click on the three dots in the top right corner of the chart, and then select Edit chart.

Under where it says Chart type, use the dropdown menu to change the chart to the one you want.

More Help on Creating Charts

If you would like more guidance with creating charts, check out the video links below. Sometimes it can be a little easier to learn through watching rather than just reading.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top