Inserting more than 6 fields in an Access chart

[Guest]

Hello

I'm trying to create a chart from a query that spits out 10 fields.(%A,%B,%C.....%N
I want to plot these 10 fields in descending order in the chart.When I use the chart wizard,I get a message saying the chart can accept a maximum of 6 fields

Anyone have ideas on how to plot more than 6?..Alternatively how do I sort among these 10 to pick say just the top 5 and plot those

Thanks
-Suyash

 

[Mark Gough]

In the design view of the report Lclick on the chart and then Lclick
properties. On the Data Tab select Row Source, and elipsis (...) will
appear on the right. When you click this it will take you to a query where
you can add additional fields.

To select the top five go to you query that you are basing your report on.
Go to SQL view and type 'TOP 5' just after SELECT.

Hello,

I'm trying to create a chart from a query that spits out 10 fields.(%A,%B,%C.....%N)
I want to plot these 10 fields in descending order in the chart.When I use

the chart wizard,I get a message saying the chart can accept a maximum of 6
fields.

Anyone have ideas on how to plot more than 6?..Alternatively how do I sort

among these 10 to pick say just the top 5 and plot those?