Copy whole of chart to existing chart

  • Thread starter Thread starter statto_stu
  • Start date Start date
S

statto_stu

HI everyone,
I am trying to change an embedded chart on a page to show various
charts throughout my workbook through use of a drop-down menu. Is there
a (relatively) simple way to copy a chart (source, styles, etc) using
VBA to an already existing chart? I know how to copy the source data
and then all the chart object styles one by one but was wondering if
there is a simple short-cut that copies everything all in one go.

Thanks for your time
 
Why not copy the entire chart? That is, once you select the chart to show,
delete the embedded chart, copy the selected chart, and paste the copy where
the embedded chart used to be. Would have the same effect but simpler and
probably faster. Just turn screen updating off while you do it so the
changes are transparent to the user.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Excel Chart into Existing Powerpoint Chart 1
Excel 2010. How to copy chart format to all charts in sheet 2
Copying charts to existing Worksheet 2
Why do charts disappear? 2
Excel chart to Powerpoint chart 1
Copying a chart included in a range 1
Chart Source when copying sheets to new file. 2
Copy embedded chart with updated data request 2

Back
Top