| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Size of Chart | Excel Discussion (Misc queries) | |||
| Chart size | Charts and Charting in Excel | |||
| Chart size | Charts and Charting in Excel | |||
| copy charts & paste as picture, hide chart, size & place same picture as chart | Excel Programming | |||
| Chart Size | Excel Programming | |||
Threaded Mode
