View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Copying charts to existing Worksheet

Turn on the macro recorder, perform the action manually, then turn off the
recorder and fix up the code.

I'm not sure it's any better to use a macro. just use Chart menu Location,
choose As Object In, and select the sheet name from the dropdown.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Michael Hudston" wrote in
message ...
I have all of my charts as existing seperate charts in a workbook. I would
like, on the push of a button (Via a macro), for Excell to copy an
existing
chart and place it on an existing worksheet.

Does anyone have any particular Idea how I can do this?

Mike