Specifying the size (in cm) of a chart ?
 

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

Specifying the size (in cm) of a chart ?
 

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

Specifying the size (in cm) of a chart ?
 

Thanks !

"Jim Cone" wrote in message
...
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