#### Archived

This topic is now archived and is closed to further replies.

# MS Access question...

This topic is 5215 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

## Recommended Posts

I know this isn't exactly programming, but I cannot figure out for the life of me how to make a pie chart and I'm getting pretty angry about it. Here is the situation: I have three colums as such:
  Concert   Commedian  Speaker
1 yes                  yes
2 yes                  yes
3           yes        yes
4 yes       yes        yes
5 yes
5           yes
6           yes

now this give me a total of 4 yes in the concert, 4 in commedian, and 4 in speaker. Now i want to make a pie chart to reflect thes numbers (in this case it should be four equal slices representing 33%). How on earth do you do this? I've figured out how to get a quary that will give me a table as follows:
  Concert    Commedian  Speaker
1 4          4          4

But I can't figure out how to turn that into a pie chart either. Please help me out here. Mike [edited by - Mike on April 5, 2004 9:16:55 PM]

##### Share on other sites
I don''t know, but usually when I hit the F1 button it usually gives me an avenue to solve my software usage dilemmas.

##### Share on other sites
As much as I apriciate the smart ass response, I've already gone that avenue and had no luck. And if it works so well for you, you give it a go and get back to me when you've found an answere.

[edited by - Mike on April 5, 2004 9:22:21 PM]

##### Share on other sites
I''ve managed to create a pie chart using a PivotTable. It''s a bit convoluted. Assuming you''ve got a table:
Concert   Yes/NoCommedian Yes/NoSPeaker   Yes/No

Then create a new form and use the PivotTable wizard. Editing the PivotTable, dragging the fields to the left hand column (you''ll see what I mean) will create totals. Then, use the Excel Insert->Chart command to create the pie chart.

Skizz

1. 1
Rutin
24
2. 2
3. 3
JoeJ
18
4. 4
5. 5

• 38
• 23
• 13
• 13
• 17
• ### Forum Statistics

• Total Topics
631706
• Total Posts
3001833
×