Apache OpenOffice Community Forum

I have a set of data I am hoping to turn into a set of pie charts. Each row in the Calc table represents one response form with five questions; each question is answered with a number from 1 to 5. (Think a response survey about a service or event)

So for example, the topmost cell in Column B is the label Clean. All other cells in column B are numbers from 1 to 5. Column C is labeled Polite, etc.

For each column, I want to create a pie chart that shows how many of each numbered response there is. So, if there are 100 hundred responses total, and 75 rated cleanliness at a 4, the Clean pie chart would show 3/4 of the circle in one color that represents response 4.

I've looked at some videos on pie charts in Calc, and looked at the documentation suggested here, and searched the forum. I've played around with the pie chart function on Calc, but not been able to get it to display the data the way I want. Is this possible or am I barking up the wrong tree?

If it is possible, how do I do it? (Feel free to point me to a tutorial or manual that spells it out)

I noticed in an earlier question about pie charts that the OP was asked to attach a sample file, so I am doing so in case it is helpful.

Thank you for the attachment. That was helpful.

kabing wrote: ↑Wed Jan 29, 2025 7:18 pm I have a set of data I am hoping to turn into a set of pie charts. Each row in the Calc table represents one response form with five questions; each question is answered with a number from 1 to 5.

I believe you have three problems.

• #1: Based on Calc Guide Chapter 3: Creating Charts and Graphs, Calc creates charts based on data values in your spreadsheet. For the Clean pie chart, those values would be 13, 2, 2, 7, 8, 1, the sizes of the six pie slices. However your cells do not contain those values. Instead you have the 33 values, and you need to count that there are 13 ones, 2 twos, 2 threes, …, and 1 dash. But you can create a pivot table for column B to get those counts. Use Count instead of Sum as the summary statistic for the pivot table.
• #2: Insert → Chart creates one chart. When you choose chart type Pie, you can specify only one column. Since you want four charts, you will have to use Insert → Chart four times.
• #3: 25 occurs twice in column A.

Summary: Create four pivot tables for columns B, C, D, and E, then create four charts. The links above will help you understand Calc's chart and pivot table features.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Thanks so much! I had begun to wonder if I didn't need to try something like this. Thanks, too, for catching the double 25s!