Dates in a Scatter Graph

[DOUG ECKERT]

Is there a way to plot dates in a scatter diagram or something similar? (The
alternative I have used is to show the number of days between the dates a
supposedly critical report was run and to graph that instead). I envision
something which would show a timeline of some kind on a graph with the actual
dates displayed.

DOUG

 

[Phil]

Hi Doug,

If the dates are valid in Excel, they should already be treated as
numbers rather than categories in a scatter graph. By valid I mean
separated by "/" or "-" like 14/11/08.

If they're just month names or years, then they'll be treated as text
- in this case you can use something like 01/01/08 in your data, and
format the X-axis in your scatter chart to read Jan 08 or whatever.

There's an article at this link that gives some useful info on
this....

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=190

Hope that helps,

Phil

 

[DOUG ECKERT]

Phil: 'Great article. Thank you very much!

DOUG