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/e...pandXLHome.htm

HTH,

Robin Hammond
www.enhanceddatasystems.com


"Srikanth Ganesan" wrote in message
...


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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!