Calling all Chart Experts

[ions]

Dear Access Chart Expert

I have been trying to figure out how I can make the x-axis show month abbreviation names instead of numbers. Please see attached gif.

Currently, I use the Month([DateField]) function to get numbers of the month because if I use Format([DateField], "mmm") to get "Jan, Feb, March" the chart sorts the months in alphabetical order instead of the correct monthly order.

How can I be able to use the Jan, Feb etc... labels and have the chart sort them in the correct month order and not alphabetical order?

Thanks so much...

greatly appreciated.

 

[boblarson]

In your query behind your chart set the order on the number but put in another formatted field for the name and use that for your data series.

 

[ions]

Larson suppose I include another field that formats the month numbers to their appropriate abbreviations ... How Exactly would I do what you suggest in the query.

There are only three options in the query please see attached gif.

 

[boblarson]

Create your base query with your fields first and THEN use that instead of the table.

 

[ions]

Hmmmm I don't understand how that will help.