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, " "Significan t," 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.
-
-
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. -
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.Comment
-
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.Comment
Comment