Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
Anchoring chart to certain placePosted 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 placePosted by Ada on July 26, 0100 6:43 PM
Assuming the chart is "Chart 1", try this code :-
With ActiveSheet.Shapes("Chart 1")
.Left = Range("U18").Left
.Top = Range("U18").Top
Re: Anchoring chart to certain placePosted 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.