Similar graphs in separate workbooks

Mar 13th, 2002, 08:46 AM

I regularly create customized charts in one workbook that refer to specified cell ranges in one of the worksheets of this workbook. It would be very convenient if I could use the customized graphs in another workbook that uses a similar layout but contains different data. Simple copyng and pasting of the charts does not work since the references to the original workbook keep existing. Is there a simple solution to transfer charts from one workbook to another where references to the cells remain valid but references to the original workbook are deleted?

Mark W. · Mar 13th, 2002, 04:11 PM

Have you tried Copying the chart object from your 1st worksheet and the using Paste Special... Formats onto the chart object(s) of your 2nd worksheet?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 08:46 AM	#1
Guest Posts: n/a	I regularly create customized charts in one workbook that refer to specified cell ranges in one of the worksheets of this workbook. It would be very convenient if I could use the customized graphs in another workbook that uses a similar layout but contains different data. Simple copyng and pasting of the charts does not work since the references to the original workbook keep existing. Is there a simple solution to transfer charts from one workbook to another where references to the cells remain valid but references to the original workbook are deleted?

Mar 13th, 2002, 04:11 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Have you tried Copying the chart object from your 1st worksheet and the using Paste Special... Formats onto the chart object(s) of your 2nd worksheet?