Inserting more than 6 fields in an Access chart

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

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.


"Suyash" wrote in message
...
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