Chart Report Problem

[Jkittle]

I'm using Access to chart scrap cost but it does not chart in descending order. Anyone know how to get an Access chart to sort on the "Y" axis?

The chart/report is based on a query and is already sorted in the query but this does not seem to matter in the report.

 

[lisa1965]

Chart properties

Right mouse click on the chart in design view and look at the properties. click on the row source property to view the SQL statment, click again to view the datasheet for this SQL statement. Put your sorting criteria on this query and your chart should now be sorted the way you want.

 

[Jkittle]

Thanks!

Lisa,

Thank you for your help this worked.