Ask Your Question

simple pivot table

asked 2018-04-09 02:32:00 +0200

bad medicine gravatar image

updated 2018-04-13 02:17:34 +0200

I have a one column spreadsheet with 3 different entries across 1200 records, basically 3 different responses to a questionaire answered by 1200 people. I need to make pivot tables showing frequency distribution by #responses for each catergory and also a table showing percentage of responses and then a pie chart. I only have instructions for excel, and can't even get the first step to work in Calc. I can't get the #s to show up, only the response categories.

Gonna try to attach a screenshot of my actual table and chart. Everything is hunky dory till I try to label the pie, but I still cant get that to happen. My table is a little different so maybe that's why.C:\fakepath\Screenshot from 2018-04-12 12:38:42.jpg

Not sure how to make that image appear inline but hopefully the link works for you.

edit retag flag offensive close merge delete


I only have instructions for excel. Why so limited? There are plenty of pivot table examples on this site as well as other places on the web. See the first bullet point in guidelines for asking.

Jim K gravatar imageJim K ( 2018-04-09 22:07:31 +0200 )edit

Sorry I'll try to be more specific next time. I did search but couldn't find any single field examples before I posted.

bad medicine gravatar imagebad medicine ( 2018-04-10 15:49:42 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-04-09 22:05:29 +0200

Jim K gravatar image
  1. Add a title for the column in the first row, for example, "Responses".
  2. With that cell active, go to Data -> Pivot Table -> Create, OK.
  3. Drag "Responses" to both Row Fields and Data Fields.
  4. Double-click on "Sum - Responses" and change the function to Count.

The pie chart can automatically show percentages, but I've also added formulas for percentages in column E. The formula in E2 is =D2/D$5, filled down to E4 by dragging.

pivot table

To create the chart, select C2 through D4 and go to Insert -> Chart.

Sample file.ods

edit flag offensive delete link more


Perfect, thank you. I had tried everything except dragging the reponses to BOTH Row and Data fields. That never occurred to me because I don't know what I'm doing yet. Hopefully it will become obvious once I go on to other operations.

This is for a free online class in statistics that I'm taking. I use Calc because I use Linux. I'm also using R so I know how to do the problems 2 ways.

bad medicine gravatar imagebad medicine ( 2018-04-10 15:47:34 +0200 )edit

answered 2018-04-09 23:27:00 +0200

m.a.riosv gravatar image

Taken the Jim sample it's possible to get the percent inside the pivot table.

Sample file

image description

edit flag offensive delete link more


How did you get the percent labels? I've got the chart now but not the labels

bad medicine gravatar imagebad medicine ( 2018-04-10 15:48:31 +0200 )edit

sorry maybe that's explained below. I'll play with it a bit. I'm very new at this.

bad medicine gravatar imagebad medicine ( 2018-04-10 17:22:19 +0200 )edit

Right-click on the pivot table and do as is on the graphic.

m.a.riosv gravatar imagem.a.riosv ( 2018-04-10 23:56:17 +0200 )edit

Hmm. That's not working for me. I can do as shown but the percents still dont show up anywhere except the table

bad medicine gravatar imagebad medicine ( 2018-04-11 04:47:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-09 02:32:00 +0200

Seen: 226 times

Last updated: Apr 13 '18