View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Wieser Thomas Wieser is offline
external usenet poster
 
Posts: 11
Default Set the size of a chart object

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