Inserting more than 6 fields in an Access chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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 said:
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
Click to expand...
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
Click to expand...
among these 10 to pick say just the top 5 and plot those?
 
Back
Top