Everything to Know About Google Sheets Charts (15 Min Guide)

A visually appealing and well-laid-out chart is at the heart of every project when it comes to visualization.

 

Luckily making charts in Google Sheets is easy, and you will create beautiful charts that visually display the data already stored in your Google Sheets file. Google Sheets Charts include numerous chart types, from simple bar and pie charts to more complex radar, treemap, and geo (using Google Maps) charts.

This Google Sheets Charts tutorial will provide you with the knowledge to create even the most complex charts on Google Sheets.

Navigating This Guide

This guide only briefly touches on a number of different chart types. However, each chart type will have a link to our full detailed guides. Alternatively, you may want to just learn everything at once from a comprehensive Google Sheets guide.

How to Create a Chart in Google Sheets

Before you start creating a chart, you need to prepare your data. You can do this in many ways, like creating a pivot table. Creating a chart is super simple and can be done in two ways. Here is a step-by-step guide on how to make a chart on Google Sheets:

Step 1: Select your data range.

Screenshot of example spreadsheet with data range selected

Step 2: Go to Insert > Chart. A chart editor will pop up on the right

Step 3: You can choose the chart type you want in the chart editor.

Step 3: You can choose the chart type you want in the chart editor.

Step 4: Under Series, you can also choose which columns you want to be presented in your chart by adding or clicking Remove.

Step 4: Under Series, you can also choose whic columns you want to be presented in your chart by adding or clicking Remove.

Once you are done, you can edit and customize your chart as you wish or close the chart editor. The second option for step two is to select the Chart button in the toolbar.

Google sheets Chart button in the toolbar.

Google Sheets will then select the chart it feels your data fits. This is an automated process and can be incorrect at times. However, often this prediction may be correct. It will create a chart and use the data to fill in the title, legend, and axes. You will also notice that the Chart editor sidebar loads at this time.

Please note that if you close the Chart editor and then want to reopen it later, you can do so by double-clicking anywhere on the chart.

Download a Copy of Our Example Sheet

If you would like to experiment with the charts in Google Sheets, you can make a copy of our chart example spreadsheet. You can also find some example chart sheets in the spreadsheet. If you find this example sheet useful, you may also want to consider checking out our paid templates.

Google Sheet Chart Types

Now that you have created a Google Sheets chart let’s look at the various charts available in Google Sheets. We will begin with the most commonly used chart and work on the more complex types of charts.

google sheets chart types

Pie Charts

Pie Charts are perhaps the most commonly used spreadsheet charts. Most people would be very familiar with a pie chart, and they do a great job of visualizing simple data. They are used commonly with budgeting as it depicts a single item (i.e., spending). Pie charts use a circle, disk, or donut divided into sections based on the data.

Example of a pie chart

How to Make a Pie Chart

Here’s a step-by-step a guide for how to create a pie chart:

Step 1: Select your data.

Step 2: Go to Insert > Chart.

Step 2: Go to Insert > Chart.

Step 3: In the chart editor, go to the Chart type drop down menu.

Step 3: In the chart editor, go to the Chart type drop down menu.

Step 4: Choose Pie chart.

Line and Area Charts

Line charts or line graphs and Area charts are very similar. Both use an x-axis to show a period (i.e., month), and the y-axis shows the metric visualized. The only difference between them is a bit more color. A line chart is a rectangular chart that has dots going across it and lines connecting the dots. Whereas, for an Area chat, the space below the line in the chart area  is shaded in. This could perhaps make the visual much quicker to identify. Both charts can be used to visualize the changes of numerous metrics over time.

Example of a line chart

How to Make a Line Chart

Here’s how to make a line graph in Google Sheets:

Step 1: Select your data.

Step 2: Go to Insert > Chart.

Step 2: Go to Insert > Chart.

Step 3: In the chart editor, go to the Chart type drop-down menu.

Step 3: In the chart editor, go to the Chart type drop down menu.

Step 4: Choose line chart.

Column and Bar Charts

These charts resemble Line and Area charts in the overall layout, but you will have columns or bars instead of dots connected by lines. They will not be connected, thus allowing you to compare multiple metrics side by side for each period (i.e., week).

A column graph

In Google Sheets, a bar chart is just like a column chart except that it is horizontal. The x and y axis are usually inverted in those cases.

How to Make Column Charts

Usually, when you insert a chart in Google Sheets it automatically comes as a column chart but just in case, here’s a step-by-step  guide on how to create a column chart:

Step 1: Select your data.

Step 2: Go to Insert > Chart.

Step 2: Go to Insert > Chart.

Step 3: In the chart editor, go to the Chart type drop down menu.

Step 3: In the chart editor, go to the Chart type drop down menu.

Step 4: Choose Column chart.

Learn more: How to Make a Bar Graph in Google Sheets

Stacked Column, Bar, and Area Charts

Stacked bar charts are similar to their standard versions. However, the metrics are stacked in different colors to show the changes in the composition of various items over time.

Example of a stacked bar chart

Scatter Charts

Scatter charts have a diagonal line (x-y plane) going from bottom left to top right moving up the metrics results. Then the data is visualized as dots around that line. These dots create a scatter plot that highlights the target areas. Often this is used to get a simple overview of property cost and square footage. It can be used effectively to show connections between two metrics.

Example of a scatter chart

Learn more: How to Make a Scatter Plot in Google Sheets

Bubble Chart

A bubble chart is a way to represent data using several circles or bubbles. It is similar to a scatter plot but uses bubbles in place of the dots, the size of each of these bubbles shows the density of a data point by including a third numerical value.

Example of a bubble chart

Waterfall Chart

A Waterfall chart is a form of data presentation that shows how a value is affected positive and negative changes. The chart consists of bars that show the beginning and ending values of a quantity, connected to each other using floating bars (or bridges).

Example of a waterfall chart

The floating bars show how the starting value rises and falls until it reaches the ending value. This kind of chart is especially common with stocks data. The bars in a waterfall chart are color-coded to show when a change is positive or negative.

Combined Charts

A combo chart is a combination of two or more different chart styles, such as the column Chart and a Line chart. It is an insightful way to view and compare multiple sets of data simultaneously.

Example of combo chart

To create a combo chart, you need two datasets with a common string field, like time.

Candlestick chart

A candlestick chart is a kind of chart used in financial analysis to chow price high, low and to determine the movement base on this pattern. One candle stick usually represents 4 important pieces of data.

In Google Sheets, a candlestick chart requires at least 5 columns of data.

Radar chart

This chart is used to present data that has multiple variables. It’s used to compare multiple aspects of more than one. It’s sometimes called a spider chart because it resembles a web.

Example of radar chart

Geo Charts

These charts use a map, and they show concentration by area. They are great for visualizing sales data when attempting to understand the target market areas of a company’s customer base. Google Maps offers a map for this chart that is built into Google Sheets Charts.

The Chart Editor

The chart editor is, as it sounds, the place where you can edit your chart. This editor will allow you to change the data range, chart type, visual effect, and more. It consists of 2 sides: the Setup Editor and the Customize Editor.

Setup Editor

chart setup editor

Data Range

  • The range used for the data.
  • Automatically selected when you selected the data table cells at the start of this process.
  • You can use the grid button to the right of the current range to choose a different range/s.

X-axis

  • The horizontal axis selector.
  • The horizontal axis is automatically set based on the data.
  • If it is incorrect or if the data changes, it can be updated here.
  • To edit the range, click the name of the X-Axis, and it will bring up the options box to select another range.
  • The Label is set based on the column label in the data table. You will need to change the column label in the data table or change it in the customize section.

Aggregate Check Box

  • This checkbox will allow you to select and aggregate data options for the data series.
  • Some data sets do not lend themselves to this, while others require it.  

Series

  • Where you view and edit your data series.
  • The Label is set based on the column label in the data table. You will need to change the column label in the data table or change it in the customize section.
  • To edit the range, click the name of the series, and it will bring up the options box to select another range.
  • You can also add new series here. These series must be the same size range, but they do not have to be consecutive. For example: if a series is in Columns B4:B17, C4:C17, and D4:D17. You could also have a series in column H4:H17.

Checkboxes

  • Switch rows/columns: This swaps the rows and columns if the table is opposite this one.
  • Use row * as headers: uses whichever row is in the table headers position.
  • Use column * as labels: uses whichever column in the label position.

Customize Editor

customize chart editor

Chart style

  • Here you can edit the overall chart elements. This is how you can create a visually appealing chart that has colors and features you select. Often users will use this to match their chart to a preexisting color scheme or branded colors.
  • You can change the background, font, and border.
  • Checkboxes:
    • Smooth: removes jagged edges from the line chart
    • Maximize: removes blank border space and enlarges to max amount.
    • 3D: this will change it to a 3D chart.

Chart & axis titles

  • In this section, you will see a dropdown that lets you select which chart title you would like to edit.
  • You can edit the Chart Title, Chart Subtitle, Horizontal Axis Title, and Vertical Axis Title.
  • You can edit the text, font, location, color, and size.

Series

  • Series enables you to edit the charts visualization.
  • This section will see a dropdown that lets you select which series you would like to edit.
  • You can now edit the color, opacity, dash type, line thickness, point size, and point type.

Legend

  • You can change the position, font, and color of the chart legend.

Vertical Axis

  • You can change the min/max value, scale format, and number format.

Gridlines and ticks

  • You can change the gridlines and ticks for both the vertical and horizontal axis.
  • The vertical axis has many more options in this example. You can change the spacing, count, color and select various ticks and gridlines.
  • The horizontal axis has only one choice in this example and provides ticks along the axis.

Difference Between a Chart and a Graph

A chart is usually an umbrella term used to define different ways to visually represent data. A graph on the other and, is used to represent data in by plotting the values in a vertical axis (y axis) and horizontal axis (x axis).

However, people often use these terms interchangeably. To help differentiate them, there are charts that you can’t call graphs, such as pie charts, geo charts, area charts, bubble charts, waterfall charts, heat maps, radar charts, and spline charts. These typically do not have an x and y axis.

Graphs on the other hand, are like line graphs, bar graphs, histograms, and candlestick charts.

One thing to note is that Google Sheets treats all graphs as charts; therefore graphing on Google Sheets is done the same way for all charts.

How to Move and Remove a Google Sheets Chart

It’s easy to move your chart around your sheet if you want to position it. All you need to do is click it and hold it with the cursor, then drag it to where you need it to be.

If you want to remove your chart there are two ways you can do this. You can cut it using the keyboard shortcut CTRL + X

For the second method:

Step 1: Click on the three dots at the top right corner of the chart to open chart options.

Step 2: Choose Delete chart.

Click on the three dots at the top right corner of the chart to open chart options. Choose Delete chart.

This will remove your cart from your sheet completely. If you happen to delete your chart by accident you can always undo using the keyboard shortcut CTRL + Z.

How to Make Google Spreadsheet 3D Chart

To make a 3d chart in Google Sheets:

Step 1: Select your data.

Step 2: Go to Insert > Chart

Step 3: Go to chart style and choose the chart you want .

Step 4: Go to Customize > Chart style

Step 5: Check the box for 3D

Make a google sheets chart 3d

How to Copy and Paste Google Spreadsheet Graph

Once you are done making a chart in Google Sheets, there are several different ways you can share your chart. One way is by copy-pasting it.

You can copy and paste the chart to a different sheet or even to Google docs.

Here’s how:

Step 1: Click on the three dots at the top right corner of the chart to open chart options.

Step 2: Choose Copy chart.

Click on the three dots at the top right corner of the chart to open chart options. Choose Copy chart.

Step 3: Go to where you want to paste your chart and right click and choose paste. You can also use the keyboard shortcut CTRL + V

Step 4: A prompt will pop up to either link to spreadsheet or paste unlinked. If you want your chart to update with any changes to the original data then click Link to spreadsheet.

Step 4: A prompt will pop up to either link to spreadsheet or paste unlinked. If you want your chart to update with any changes to the original data then click link to spreadsheet.

Step 5: Click Paste.

Your spreadsheet will be pasted into the new location you have chosen. If you chose paste unlinked then it will be pasted simply as an image.

Downloading Your Chart

After creating a chart, you may need to download it to distribute it to your team via email. Luckily Google Sheets has this built-in and allows you to download your file to a PNG, PDF, or SVG. To do this, you will need to hover your cursor over the chart. When you do this, three dots should appear in the top right corner of the chart. Click the three dots, and you will see a dropdown. Go to Download and select the file type you would like to download.

Download your chart

Advanced Tips

Google Sheets Charts have some more advanced options that we will not cover in full here, but this will provide you with other options for your chart.

  • Google Sheets charts can be published by creating a link and allowing people to view by accessing the link.
  • Google Sheets Charts can be connected directly with Google Presentations allowing you to update the data in the sheet without adjusting your presentation each time.
  • If you can use Google App Script, you can program your sheet to email a PDF or PNG created from a Google Sheets Chart to a list of team members at the same time every day/week/month.

Conclusion

Google Sheets Charts are a top-shelf data visualization tool that will create visuals to present your data. These visualizations are the key to making informed decisions and delivering effective points. We’ve shown how to make a chart in Google Sheets ad some examples of different charts.

Hopefully, this tutorial will allow you to use this incredible tool effectively, and you will become more effective at making charts in Google Sheets.

Read more Google Sheets chart tutorials here:

Most Popular Posts

Jon Flatt

Jon Flatt

Jon has worked in administrator positions for the last decade and has a specific knack for using Google Sheets to help small businesses. Jon consistently applies his skill set to allow small businesses and new Google Sheet users to advance and grow.