If you have anything other than a XY Scatter chart, XL has probably set
your x-axis type to 'Time scale'. Unfortunately, that is bad choice of
a name because it is only a 'date scale'. The only alternative is to
set the type to 'Category' (select the chart then Chart | Chart
Options... | Axes tab). Unfortunately, that will mean all your data
points will be equally spaced along the x-axis.

If you are using a line chart, change your chart type to a XY Scatter
chart (sub type: the kind that has a connecting line between the
points).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have date and time in my first column for my x axis, but I can't get both
date and time to display in the chart.

My data spans two weeks and now displays as I want it, but the data is
useless without showing the relevant date/time for the data points (across
the bottom of the chart).

Is there a work around for this. I've tried different date/time cell
formats which will display as I want it in the cell, but can't get the same
display in the chart. I'm not sure what I'm doing wrong.

Thanks for any help. Diana