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