[Solved] Basic pie chart creation

[leatherneckpa]

OS: Windows Vista
OO version: 3.3

I have just completed my student teaching. One of my remaining tasks is to create graphic aid to demonstrate the level of learning achieved by my students. I would like to do that with a pair of "Before and After" pie charts comparing pre-unit and post-unit grades. I know how to create the basic spreadsheet, but when I try to "Insert Chart" I get a pie with 25 little wedges. What I would ultimately like is for the slices to approximate the percentage of students who fall into each category. That "Exploded Donut" style looks interesting also. This is the spreadsheet I am working from:

[MrProgrammer]

I would use Data > DataPilot first. Drag Pre-test to Row Fields, then drag it again from the right to Data Fields and use Options > Count. Repeat to create a second DataPilot for Post-Test. Plot the results.

In the future consider that it is far easier for the volunteers here to help if you attach your data instead of providing a picture because anyone who wants to run some tests first has to retype your data from the picture. I didn't do that since it's too much work.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[leatherneckpa]

I would use Data > DataPilot first. Drag Pre-test to Row Fields, then drag it again from the right to Data Fields and use Options > Count. Repeat to create a second DataPilot for Post-Test. Plot the results.

Okay, I'll give that a try.

In the future consider that it is far easier for the volunteers here to help if you attach your data instead of providing a picture because anyone who wants to run some tests first has to retype your data from the picture. I didn't do that since it's too much work.

Sorry. I'm afraid I don't know how to do that either.

[leatherneckpa]

I sort of stumbled into my own answer. Perhaps some of the superbly talented individuals on this forum can do what I wanted to do with my original data but I couldn't. For the non-talented shmucks, like me, all I did was do another spreadsheet with the grades all grouped and counted by me instead of the program. Then with only four rows and three columns I was able to create the donut chart I wanted. I suppose computers are not a complete replacement for human work, yet.