I am generating a chart in a form with the record source a query. How do i display the data in the chart in asc or dsc order. I have done that in the query, but somehow it doesnt display sorted in the chart

thank you