View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Pong[_2_] Alan Pong[_2_] is offline
external usenet poster
 
Posts: 2
Default Set Xvalues to an array of date, but the x-scale not correct

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!