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!

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!