Copy whole of chart to existing chart
 

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


--
statto_stu
------------------------------------------------------------------------
statto_stu's Profile: http://www.excelforum.com/member.php...o&userid=28739
View this thread: http://www.excelforum.com/showthread...hreadid=484796

Copy whole of chart to existing chart
 

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.
--
- K Dales


"statto_stu" wrote:


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


--
statto_stu
------------------------------------------------------------------------
statto_stu's Profile: http://www.excelforum.com/member.php...o&userid=28739
View this thread: http://www.excelforum.com/showthread...hreadid=484796