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.

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.

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.