Xavier,

I used 2.54 cm/Inch and 72 Points/Inch.
Two slightly different ways to size the ChartObject.
The ChartObject is the container for an embedded chart.
'-----------------------
Sub MakeItToSize()
ActiveChart.Parent.Width = 567
End Sub

Sub JustLikeIWant()
ActiveSheet.ChartObjects(1).Width = 567
End Sub
'-----------

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Xavier" wrote in message ...
Hello,
I am currently generating some charts via VBA on Excel 2003. I would like to
resize these charts so that they would have a width of 20 cm. I could not
find a way to achieve this (neither did google return relevant info).

Any help would be appreciated.
Thanks,
Xavier