# simple pivot table

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 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.

( 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.

( 2018-04-10 15:49:42 +0200 )edit

Sort by » oldest newest most voted
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.

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

Sample file.ods

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.

( 2018-04-10 15:47:34 +0200 )edit

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

Sample file

more

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

( 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.

( 2018-04-10 17:22:19 +0200 )edit

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

( 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

( 2018-04-11 04:47:03 +0200 )edit