How to☝️ Create a Pivot Chart in Google Sheets

To create a pivot chart in Google Sheets, highlight your data, go to the Insert menu, choose Pivot table from the list, select the location you need to insert the table, and hit Create. Next, click on the Add button to add the suggested Rows, Columns, Values, and Filter. Then choose the options you need to add. Following that, select the Pivot table, go to the Insert menu, and click Chart

In this article, you can find out what a pivot chart is and how you can create one easily using the step-by-step instructions provided!

 

What Is a Pivot Chart?

A pivot chart is an interactive tool that allows you to visualize and explore data in new ways. Google Sheets allows you to use a pivot chart to summarize data, show relationships between different data points, and compare data without having to scroll through long lists or tables.

What Is a Pivot Chart

What’s the Difference Between a Regular Chart and a Pivot Chart in Google Sheets?

Pivot charts and regular charts are both useful tools for representing data visually. In spite of this, there are some significant differences between the two types of charts.

A regular chart is typically used to visualize data that is already organized in a specific way. For example, if you have a dataset that contains information about different types of products and their sales figures, you could use a regular chart to compare the sales of each type of product.

The pivot chart is more flexible and can be used to show data that is not as easily organized. Using this chart, you will be able to compare data regardless of its type.

How to Create a Pivot Chart in Google Sheets (Step by Step)

The first step to creating a pivot chart is to make a pivot table. Take a look at the detailed description below on how to create a Pivot table so you can make your own with no trouble at all.

  1. Select the data you need to add to the Pivot table.
  2. Go to the Insert menu.
  3. Pick Pivot table.

How to Create a Pivot Chart in Google Sheets

  1. Next, choose the location where you need to insert the Pivot table. Here we use the New Sheet option.
  2. Click the Create button. 

Create a Pivot Chart

Now let’s move on to adding options to your table!

  1. Click the Add button to add the suggested rows.
  2. Select the row you need to add.

Pivot Table Editor

Repeat the action to add other rows as needed. And now your table is ready to go!

What Is a Pivot Table

Let’s get down to Columns, Values, and Filter options. In our example, we need to add the Values

  1. Click on the Add option.
  2. Choose the appropriate category.

The Add option

Voila! You have created a pivot table! Let’s move on to the next step.

Pivot Table

  1. Select the Pivot table.
  2. Navigate to the Insert menu.
  3. Click on Chart

The Insert Menu

Easy-peasy! A pivot chart has now been created from your pivot table.

The Chart

If you don’t like the default chart, you can easily change its type:

  1. Double-click on the chart.
  2. Go to the Setup menu.
  3. Click on the Chart type option.
  4. Pick a chart you do like.

Chart Editor

Congratulations! You have done it!

What Is a Pivot Chart

Pivot Charts in Google Sheets FAQs

For more information, you can check out our FAQs section below.

When should you use a pivot chart?

You should use a pivot chart if you need to summarize large amounts of data visually.

For example, you could use it to show your data and see which weeks, months, or years had the highest or lowest sales or prices, how they changed over time, and so on. With the help of this chart, you will be able to compare data regardless of its format.

What are the pros and cons of using a pivot chart?

If you’re considering using a pivot chart, it’s important to weigh the pros and cons before making a decision.

Pros 

  • It is one of the best ways to summarize and visualize data quickly and easily.
  • It can be used to show trends over time or to compare different groups of data regardless of its type.

Cons

  • They can be tricky to set up, and they may not always be accurate. 
  • They can be difficult to read if they contain a lot of data.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X