View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Set Xvalues to an array of date, but the x-scale not correct

To the best of my knowledge, that isn't supported. (although you claimed
you achieved what you want manually)

Perhaps you want to use a logarithmic scale.

--
Regards,
Tom Ogilvy


Alan Pong <no_spam_please wrote in message
...
Tom, thanks for suggestion (using CLng).
yes, your sub-routine shows a curve with x-scale like this:
p1----p2----p3----p4


however, what i want the x-scale is, like this:
p1---p2-------p3---------------p4

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!