Chart.Axes().MinimumScale Not WORKING

[ddm]

hi,

i have an excel application that unable to draw a chart in excel 2007, in
previous version of excel, it work fine.

and i found out that this error cause by

x.Chart.Axes().MinimumScale=0 It failed to assigned value to
MinimumScale, i has tested it, i think it only has read permission whether
than re-Assign Value to this property (.MimumumScale).

any idea ?

DDM

 

[Andy Pope]

Hi,

Are you sure that exact code worked in previous versions?
This works in xl2003 and xl2007 when setting the Y axis


Dim x As ChartObject

Set x = ActiveSheet.ChartObjects(1)
x.Chart.Axes(xlValue, xlPrimary).MinimumScale = 0

If you still have problems post back with details on the type of chart
and the code for declaring and assign x

Cheers
Andy

 

[ddm]

Hi Andy,

The Code will like below,

Private ws as WorkSheet
Dim oChart as ChartObject
set oChart=ws.ChartObjects("Chart_" & Format(miId,"00"))
oChart.Charts.Axes(xlCategory).Minimumscale=0

the application error at above line, and i has check line above, i able to
display the value inside the minimumscale but unable to assign value to it.

and all this code inside an Add-in.

regards
DDM "

 

[Andy Pope]

Hi,

Try this revision

oChart.Chart.Axes(xlCategory).MinimumScale = 0

Cheers
Andy

 

[ddm]

hi Andy,

It seems that still giving same error.

DDM

 

[Andy Pope]

Hi,

If you want to prepare a small example file and email it to me I will take a
look.

andy AT andypope DOT info

Cheers
Andy