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" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info