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