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