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

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" <(E-Mail Removed)> wrote in
message news:A338B960-813E-4838-87AA-(E-Mail Removed)...
>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

Cheers Jon, with a little fettling that worked fine. I dont normally have
success with just recorded macros, because it assumes too much.


"Jon Peltier" wrote:

> 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" <(E-Mail Removed)> wrote in
> message news:A338B960-813E-4838-87AA-(E-Mail Removed)...
> >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
>
>
>