View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
art art is offline
external usenet poster
 
Posts: 22
Default Moving Chart Objects


How can I do this with the active chart? I want to create a chart, move it to a specified position (A1), create another chart and move it to a different position (A20), and so on

Thanks

Ar

----- Tom Ogilvy wrote: ----

Not sure how this looks in Excel forum, but here in the newsgroup th
period/fullstops have been remove

with ActiveSheet.ChartObjects("mychart"
.top=range("D3").to
.left=range("D3").Lef
end wit

also, .left=range("D3").top was a typo - corrected above


--
Regards
Tom Ogilv


"i-Zapp " wrote in messag
..
with ActiveSheet.ChartObjects("mychart"
top=range("D3").to
left=range("D3").to
end wit
--

Message posted from http://www.ExcelForum.com