Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in a Scatter Graph
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in a Scatter Graph
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/p...cle.asp?ID=190 Hope that helps, Phil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in a Scatter Graph
Phil: 'Great article. Thank you very much!
DOUG "Phil" wrote: 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/p...cle.asp?ID=190 Hope that helps, Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should I use a scatter graph? | Excel Discussion (Misc queries) | |||
Should I use a scatter graph? | Charts and Charting in Excel | |||
Shading on a scatter graph | Charts and Charting in Excel | |||
scatter graph | Charts and Charting in Excel | |||
XY scatter graph | Charts and Charting in Excel |