Autoformatting data on x-axis as a date - incorrectly!

[Newbie456]

Ugh. I have a chart with the x-axis labels as intervals with the values "0-10, 10-20, 20-30, etc." The only problem is that Access is autoformatting the "10-20" field as "20 Oct" on my chart. How do I get it to stop doing this?? It should read 10-20, not 20 Oct, which doesn't make any sense.

The data is coming from a query, based on a table where the values used on the x-axis are text. I've tried changing it in view, but when I go back to print preveiw, it still says "20 Oct."

Please make it stop.

Thanks.

 

[Remou]

I think the easiest way to fix this would be to add a space before each x-axis label.
I stumbled across this article, I only skimmed it, so I can't really comment on it:

http://www.vb123.com/toolshed/99_vbchart/vbchart1.htm

PS I suppose you mean 0-9, 10-19, ...
Or 1-10,11-20, ...

 

[Newbie456]

Why didn't I think of that, thanks! I'll check out the other site too.