Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Irregular dates | Charts and Charting in Excel | |||
Troubles with irregular dates | Charts and Charting in Excel | |||
Dates and times with PST,PDT | Excel Worksheet Functions | |||
Plotting Dates | Excel Worksheet Functions | |||
Times and Dates | Excel Discussion (Misc queries) |