Size and location of chart
 

Hi All

I'm writing a VBA proc to create a chart in a worksheet, but it seems to be
created at an arbitary size and location.

Has anyone got any idea how to control the size and location of the chart
object?

Thanks

Mark

Size and location of chart
 

Jon Peltier has some code samples that show how to add a chart with a
specific size and location.

http://www.geocities.com/jonpeltier/...kChartVBA.html

Mark Anderson wrote:
I'm writing a VBA proc to create a chart in a worksheet, but it seems to be
created at an arbitary size and location.

Has anyone got any idea how to control the size and location of the chart
object?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html