Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the size of a chart object
Hi Thomas;
If you want 3600 pixels: 3600 * 3/4 =2700 points Worksheets(1).ChartObjects(1).Width = 2700 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the size of a chart object
Hi Michel,
I see, thanks. Yes, I found out yesterday evening after my posting that the factor must have to be 1.3 periodically - 4/3, as you mentioned. Now I am sure - thank you! Greetings from Austria, Thomas Michel Pierron schrieb: Hi Thomas; If you want 3600 pixels: 3600 * 3/4 =2700 points Worksheets(1).ChartObjects(1).Width = 2700 Mp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i export a pivot chart as a static chart object? | Charts and Charting in Excel | |||
Dynamic Chart Object | Excel Discussion (Misc queries) | |||
Calendar - change of a size of this object | Excel Worksheet Functions | |||
size of embedded object | Excel Discussion (Misc queries) | |||
is object chart? | Excel Programming |