View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Phil Phil is offline
external usenet poster
 
Posts: 31
Default 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