View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rainer[_2_] Rainer[_2_] is offline
external usenet poster
 
Posts: 1
Default tuntime-error 1004 when trying to rescale a chart

when trying to rescale a chart by means of

With ActiveChart.Axes(xlCategory)
.minimumScale=-.05
.maximumScale=1.95
End With

I always get a runtime error 1004 in line .minimumScale=-
..05
"Die MinimumScale-Eigenschaft des Axis-Objektes kann nicht
festgelegt werden" (I'm german and EXCEL speaks german
with me)

I've got the code by using the macro recorder.

I've also tried .minimumScaleIsAuto=True but I doesn't
work either.

I would be glad if anybody can give me a hint.

Many thanks in advance
Rainer