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
|