Date/Time not displaying correctly in Chart

[GnortenJones]

I have a chart pulling data from a table with a date/time field being used as the x-axis.

The table has the date/time in the following format: 7/26/07 15:00

However, the chart won't displaying the hour field correctly. It'll display the following: 7/26/07 0:00

I've tried changing every chart option I can think off, but can't get the time field to display correctly. This is a problem because we have several entries each day which are time stamped, but their getting all lumped onto the same date/time on the chart.

Any suggestions would be appreciated.

Thanks.

 

[Glove_Man]

Change from a line graph to an X/Y Scatter. The line graphs has a minimum scale of 1 day, but the x/y accepts fractional days.

Philby

 

[Glove_Man]

Note that by formatting the data series you can achieve a graph which visually has a line, despite it being stored as an X/Y scatter, simply turn off the dots and turn on the lines in the Format Data series box.