tuntime-error 1004 when trying to rescale a chart

R

Rainer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to define title rows -1004 ... 2
Chart Type - numeric values 3
Graph - Runtime Error 1004 5
Problem when trying to set axis properties of a chart by VBA 2
Run-time error '1004' unable to get the ChartObjectsproperty of the Chart class 1
Chart Creation using VBA 1
Chart Error when using Chart Line - Column on 2 Axes in vba code 2
Ordering of bars in VBA charts created with ChartWizard and union() 4

Top