Plotting Irregular Dates and Times
 

I have data that is formatted mm/dd/yyyy hh:mm with associated Y-axis values.
I want the y axis data to be spaced properly on the x axis. With the auto
format or Date formated x-axis the smallest unit is a day; is there a way to
space out the hours and minutes as well? For example,

Date and Time Duration
8/17/2007 10:04 40 seconds
8/18/2007 12:27 25 seconds
8/18/2007 15:35 40 seconds
8/19/2007 13:14 60 seconds

With the settings I am using now, I only get 1 column for the 18th, but it
should have two. Any suggestions, or am I at the limitations of the software?

Plotting Irregular Dates and Times
 

Try an XY chart rather than a Line chart
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Albie" wrote in message
...
I have data that is formatted mm/dd/yyyy hh:mm with associated Y-axis
values.
I want the y axis data to be spaced properly on the x axis. With the auto
format or Date formated x-axis the smallest unit is a day; is there a way
to
space out the hours and minutes as well? For example,

Date and Time Duration
8/17/2007 10:04 40 seconds
8/18/2007 12:27 25 seconds
8/18/2007 15:35 40 seconds
8/19/2007 13:14 60 seconds

With the settings I am using now, I only get 1 column for the 18th, but it
should have two. Any suggestions, or am I at the limitations of the
software?

Plotting Irregular Dates and Times
 

That works

"Bernard Liengme" wrote:

Try an XY chart rather than a Line chart
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Albie" wrote in message
...
I have data that is formatted mm/dd/yyyy hh:mm with associated Y-axis
values.
I want the y axis data to be spaced properly on the x axis. With the auto
format or Date formated x-axis the smallest unit is a day; is there a way
to
space out the hours and minutes as well? For example,

Date and Time Duration
8/17/2007 10:04 40 seconds
8/18/2007 12:27 25 seconds
8/18/2007 15:35 40 seconds
8/19/2007 13:14 60 seconds

With the settings I am using now, I only get 1 column for the 18th, but it
should have two. Any suggestions, or am I at the limitations of the
software?