Pie Chart in MS Access 2007

[BikeToWork]

I have table data consisting of the number of records in another table, categorized by significance with a number for each field representing the number of records for each category. The fields I want to use in the chart are "Empty," "Informational," "Significant," and "Critical." Each of these fields has a number representing the record count for the corresponding category. I thought it would be possible to make a pie chart based on a query with these four fields and have each slice of the pie represent the number from each field. This does not work and I cannot figure out how to "flatten" the data out so that it groups by the field name and has a count of the corresponding numbers. The chart wizard seems rather counter-intuitive. Any help would be most appreciated.

[twinnyfo]

I find working with Charts and Graphs in MS Access to be one of the most frustrating engagements I can think of. I know that you have to fiddle with it until you get the right combination of Query, chart and options (and a little bit of holding your motuh just right). Without actually getting my hands on it, I am not sure I will be much help on this one.

[Rabbit]

If what you actually have are fields, i.e. columns in a table, that probably won't work. You don't need to flatten your data, you need to normalize it.

[BikeToWork]

Rabbit, thanks for the tip. I made a function that takes the existing data from the original table and normalizes it into a temp table that the pie chart is based on.