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?

"Teddy" wrote:

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