Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
tuntime-error 1004 when trying to rescale a chart
try it with
ActiveChart.Axes(xlValue) I don't program charts much, but that seems to work here. -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart generation: Run time Error '1004: Method 'Cells' of object'_Global' fai | Charts and Charting in Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
excel chart export error runtime 1004 | Charts and Charting in Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Rescale the Chart Dynamically - I have briefed my situation. | Excel Programming |