Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

best way to position graph?

Posted by doug on February 21, 2001 11:52 AM

currently i am just moving the graph where i want it in my macro, is there a way i can say i want the graph to be placed in a certain place? If anyone can help i would be imensely grateful.

Re: best way to position graph?

Posted by Celia on February 21, 2001 4:51 PM

Doug

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

Celia

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.