Pivot tables help you summarize and analyze large datasets by displaying the information in more digestible formats. They make it much easier to take out small pieces of information and conclusion 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 Report

pivot-table-report

  • Once you click on Pivot Table Report, 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.
insert-chart

Shares

UP NEXT: New Search Operators in Gmail

Leave a Reply

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

Notify of
avatar

Sort by:   newest | oldest | most voted
Alicia
Guest
Alicia
February 25, 2013 9:58 pm

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
February 27, 2013 10:30 am

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
June 5, 2013 4:21 pm

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
August 22, 2013 10:16 am

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
March 4, 2015 11:48 am

Very helpful. Thank you.

B.Baker
Guest
B.Baker
March 4, 2015 3:04 pm

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?

wpDiscuz
Loading Facebook Comments ...

REGISTER

FOR OUR WEBINAR TO GET
THE LATEST 451 RESEARCH REPORT


REGISTER HERE