Pivot tables help you summarize and analyze large data sets by displaying the information in more digestible formats. They make it much easier to take out small pieces of information and conclusions from a large set of information.

  • To create a pivot table in a Google Sheet, first select all of your data.
  • Then go to Data on the top menu.
  • Select Pivot Table.
  • Once you click on Pivot Table, you will be led to a new page on your Google Sheet with your pivot table.
  • On the right side of your screen, you can determine the rows, columns, values, and filters for your pivot table.
  • Once you set your values, you can also create a chart out of your data.
  • To create a chart, click on Insert Chart on the top navigation menu.

Shares

UP NEXT: New Search Operators in Gmail

Leave a Reply

10 Comments on "How to Create a Pivot Table in Google Sheets"

Notify of
avatar
Sort by:   newest | oldest | most voted
Alicia
Guest
Alicia

Hi there Google Gooru,

I created a Pivot Table but the data for that Pivot Table is updated on a daily basis.

Is there a way for the data range of the Pivot Table to automatically update? Currently I have to manually update the range in order for the Pivot Table to be accurate.

Thanks!
A

Catherine
Guest
Catherine

Hi Gooru,

Is there a way to do a side by side chart, with 2 x y-axis in a Google spreadsheet?

Finn
Guest
Finn

Great site!

I’m creating a google spreadsheet pivot chart –and trying to remove the grand totals.
I have data label called “priority 1” in “rows” and the same in “values” so i can count each unique text and count the number of times one appears, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off.

Thank you,

finn

zack
Guest
zack

Hi, previously i am using excel and do my pivot table from excel. How do i open my excel file in google spreadsheet and do the pivot table. I have tried open but unable to do the pivot table. Please help.

J Korder
Guest
J Korder

Very helpful. Thank you.

B.Baker
Guest
B.Baker

I collect data for 500+ students. Each quarter I need to add another score so that by the end of the year I have all 4 scores for each student. each quarter I add the new data sheet to the workbook. At the end of the year I have to look on 4 different workbook pages to see a students scores to check progress. I would love to have all scores on one workbook page. Is this possible?

Barnabas
Guest
Barnabas

Hi Google Gooru,

I had a buddy create a pivot table in excel and I’m trying to duplicate it in google sheets but am having trouble. Any chance I send you the excel and get some direction on how to generate the same pivot table in google sheets?

wpDiscuz