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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACC2000 Month-Year sort in charts 1
Reversing Dates Sequence along X axis in a chart 3
Charts & Numeric Fields for Linking (?) 3
Chart help 3
How to chart months by financial year 0
Line chart report 3
Chart 1
Chart help - Y Axis question 1

Back
Top