New to Chart/Report - Cant make it work

[simpleton]

I created a nice little Query that totals up all my data.
Problem is, I can't seem to get the Chart-Builder to make this for me correctly.

Here's what my Query returns:

CategoryID  R1   R2   R3   R4   R5   R6  AVG      
1                91   91  82   82   82   82    86
2                75   75  75   75   75   75    75
3              100 100  100                     100
4              100    86   86  86 100           92
5              100  100 100  100               100
6                75   75  75    50   75          70
7               100  100 75   100  75          92

(sorry for the poor formatting, but i hope you get the idea)

These are obviously percentages (that I totaled based on data)
How in the heck can I get this into a Chart?!?!?
No matter what I try, I keep getting crap.

 

[ezfriend]

How different is it to have this run on a report than a chart?

I guess the correct question is what kind of chart are you try to create?

If your query already returns the data above, it should be easy to just run a report wizard to create a report based on your query.

 

[simpleton]

Thanks.

I did go ahead and just make a data-report.
I do still need to do a chart though.

When I use the chart wizard, I can only pick 6 columns.
And the data always seems to come out funky.