Chart size/position

[Srikanth Ganesan]

How to specify exact chart size and position when the chart is placed as
an object in a sheet. Also how to fotmat a chart?

I am trying to plot many charts and put them all in one sheet and format
them so that finally print them.

Srikanth

 

[Robin Hammond]

Srikanth,

If you want to save some time figuring this out you might want to check out
the chart browser in my XspandXL add-in. There's a lot of chart
manipulation, positioning, formatting and other routines included in a
"chart browser" that works a bit like an image browser on all charts in a
workbook. You should be able to get what you want done with the 30 day demo.

http://www.enhanceddatasystems.com/ed/pages/XspandXLHome.htm

HTH,

Robin Hammond
www.enhanceddatasystems.com