View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Line up graphs

Try something like

ActiveSheet.ChartObjects(1).Top = Range("E5").Top
ActiveSheet.ChartObjects(1).Left = Range("E5").Left


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"S" wrote in message
...
Hi I am just wondering is it possible for me to line up graphs in macro?
For
instance, I want to line up the top left corner of a graph with cell "E5".

Thanks!