sorting in a chart

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I made a chart where the bottom axis is the month. Im
having trouble keeping it in chronological order. I want
it listed as "Jan, Feb," etc. but it places them in
alphabetical order. Can I get it to order by a seperate
numeric month field or do I need to use the numeric field
as the axis and change it to text somehow?
 
The sorting is based on the sorting in the Row Source query. Sort this query
by Month([DateField]) and the chart will be sorted.
 
Back
Top