Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying charts to existing Worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying charts to existing Worksheet
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a chart and data to existing worksheet | Charts and Charting in Excel | |||
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template. | Excel Programming | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
Question when Copying an Existing Worksheet | Excel Worksheet Functions | |||
Copying a worksheet from a different file into existing (VB-6/VBA/ | Excel Programming |