Best Chart to Use

[swalsh84]

I have a table that keeps track of a loan type, the number of comments on the notes screen, and the number of loans with that number of comments:



For example:

 
Type Comments NumLoans
1    1        100
1    2        50
2    1        8
2    3        70

Etc.

I'm trying to graph this data with the loan types as different colors and the "coordinates" for the data marked appropriately on my chart with the right color. What Access seems to be doing is differentiating each record as a separate grouping and not allowing me to get all of loan type 1 as one color with its comments and number of loans, and loan type 2 to follow suit, etc.

I have been fiddling with this for three days and cannot for the life of me figure out what I'm doing wrong.

Any thoughts?
TIA

[ajetrumpet]

graphs will give you one line and/or bar for each group, but it runs a query itself before doing this. I'm not sure what you're trying to get it. hard to understand.

what would the final data look like if you queried it out using a crosstab? in other words, what do you want it to look like as a dataset?

[swalsh84]

You clued me into the piece that I was missing. I was not trying to do this as a crosstab query. I was summarizing the data before getting it to the graph, so I stopped that and let the graph summarize.

CrossTab won and I got the information set up properly. Thanks!