Changing Format in Chart Report

C

Carl

I am trying to create a chart report based on a simple
table. The data I want to use as the X axis has a text
format in the original table (although it does look like
16/04, 17/04 etc I do not want Access to handle it as
dates).

When I create a Chart Report, using the report wizard
Access automatically converts the text for the X axis into
a date (16-Apr-2004, 17-Apr-2004 etc).

Please can anyone tell me how I can retain the original
text format when I create the chart?

Thanks a lot

Carl Sprake
Oxford UK
 
Top