View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teddy[_3_] Teddy[_3_] is offline
external usenet poster
 
Posts: 8
Default setting ActiveChart.Axes(xlCategory).MinimumScale not working

Hi

Following code does not have any effect.
What di I miss??

Excel 2007
XY plot
X axis is date and hour

min_date = Sheet2.Range("start_tid").Value
Sheet2.ChartObjects("Diagram 4").Activate
ActiveChart.Axes(xlCategory).MinimumScale = min_date

Thanks cheers