Here's a Question on Axis Labelling

[dakota81]

I've got my chart in my report all set up, but I think Access identifies my labels as dates and reformates the output. Examples:

"June 02" becomes "2-Jun"
"J02" becomes "J02"
"Ju02" becomes "Ju02"
"Jun02" becomes "2-Jun"
"Jun2" becomes "2-Jun"
"abc02" becomes "abc02"

I'm defining the labels within the query that the graph is bounded to, such as:

"SELECT [1] As [Jun02] FROM [GraphSetup]"

Is there something I'm missing in the options that's causing this renaming of the axis labels?

 

[shannonp]

I have the same problem, I'd LOVE to know if there were some way of circumventing how an access chart automatically alters a chart label if it recognises it as being a date value.

I keeping a close eye on this one!