View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron Michel Pierron is offline
external usenet poster
 
Posts: 214
Default Set the size of a chart object

Hi Thomas;
The unit used by Excel is the point.
3600 points in pixels = 3600 * 4/3 = 4800
MP

"Thomas Wieser" <wernze.nospam@gmx_net a écrit dans le message de
y.telekom.at...
Hi,

I want to set the width of an chart (with legend inside) to 3600 pixels.
I try to set it with

Worksheets(1).ChartObjects(1).Width = 3600

The problem is: When I do the Export function afterwards to save the
chart to a PNG file, the file width is 4800 pixels!


Can anyone see the error? How can I export the chart in the size I want
it to?

Thanks, Thomas