Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

Anchoring chart to certain place

Posted by Nikki on July 26, 2000 4:34 PM
Hi. Can anyone tell me how to anchor a chart to a specific site in a macro? The upper left corner of chart should be around U18 and the center is around Y26 if that helps. Thank you so much. Nikki

Check out our Excel VBA Resources

Re: Anchoring chart to certain place

Posted by Ada on July 26, 0100 6:43 PM

Nikki
Assuming the chart is "Chart 1", try this code :-

With ActiveSheet.Shapes("Chart 1")
.Left = Range("U18").Left
.Top = Range("U18").Top
End With

Ada



Re: Anchoring chart to certain place

Posted by Nikki on July 26, 0100 10:01 PM
Thanks Ada, I'll give it a try. Nikki


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.