How to assign a chart's location in a spreadsheet.... 1

[Titusman]

Can anyone tell me how programmatically assign a chart to a specific location in a worksheet? I've got a number of charts to insert programmatically and I would like them to line up, but Excel will stack them on top of each other. Can anybody help?

 

[SkipVought]

Hi,

Each chart has .Top and .Left properties. You could assign these using some algorythm OR...

determine a sheet cell to reference the top left corner of the chart. Then using the .Top & .Left properties of the cell, assign the chart's position.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Titusman]

Thanks Skip! Worked Great!