setting ActiveChart.Axes(xlCategory).MinimumScale not working

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

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
 
I'd suggest looking at what you have for Min and Max axis scales before you
make a change. Is it possible that your min value is > than your Max value?
 
Back
Top