Plotting Date and Time on the same chart axis
 

I'm plotting data on the y-axis of a XY (scatter) chart, but I want to plot
it against time without the time looping back on itself, i.e. i want to have
the x-axis starting at midday on say the 18th of Feb and finishing at the
same time on the 19th of Feb. Is this possible?

At the moment the x-axis runs between midnight to midnight and doesn't
acknowledge the change of date so the data is being mixed up.

Plotting Date and Time on the same chart axis
 

Your data values must contain dates, not just times. You can pick a number
format that doesn't show the date part of the value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"mccredda" wrote in message
...
I'm plotting data on the y-axis of a XY (scatter) chart, but I want to
plot
it against time without the time looping back on itself, i.e. i want to
have
the x-axis starting at midday on say the 18th of Feb and finishing at the
same time on the 19th of Feb. Is this possible?

At the moment the x-axis runs between midnight to midnight and doesn't
acknowledge the change of date so the data is being mixed up.