Even better, use an XY chart. You need the full date and time values in
the cells containing the X values.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/9/2010 9:39 PM, water wrote:
You can try changing the axis to text format

"Midjack" wrote:

How can I create a time-date graph such that the values are plotted at the
correct time positions within the date range rather than all on the date
vertical axis?

N N
N N
N N
N N THIS
N N
N N
Jan 1 Jan 2

Rather than
N N
N N
N N NOT THIS
N N
N N
N N
Jan 1 Jan 2