Thanks, forgot to mention I am in Excel 2007. I've tried everything and can't
get it right!

"Bernard Liengme" wrote:

Excel is being a little too helpful.
Right click the chart; from shortcut menu select Chart Options
Open Axes tab and select for x-axis Category rather than Automatic or
Time-Scale
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Skip4t" wrote in message
...
I have 5 dates in a series of data: -
31/12/07
31/01/08
28/02/08
31/03/08
30/04/08
when I create the chart these dates appear as: -
01/12/07
01/01/08
01/02/08
01/03/08
01/04/08
How can I get the dates on the axis to match the dates in the data series?