How to duplicate a chart that relies on dynamic named ranges

[Mike C]

Hello - I have created a dynamic chart that shows the most recent 12
months of data.

So, for example, one of my series value sets is based on the defined
range:

=OFFSET('Dynamic Chart'!XValues,0,3). And "Xvalues" is a defined
range that uses the Counta function to show the most recent 12 months
of data.

The chart works well. But the problem is that I don't know how to
duplicate the chart into other worksheets. Is there a way to transfer
the defined names AND the series from a chart so that I can duplicate
such a chart in other worksheets and in new workbooks.

When I simply copy and paste the chart into a new spreadsheet, or when
I copy the sheet (via Right click > "Move or copy"), the chart does
not read the series correctly.

I guess one options is for me to repeatedly resave the workbook as a
new name. But I would imagine that there has got to be a way to copy
a chart (and the corresponding named ranges and series), so that it
will function the same way in a new spreadsheet or workbook.

Any suggestions are appreciated....

 

[Shane Devenshire]

Hi Mike,

Open both files and tile them. In the file with the defined names, hold
down the Ctrl key and drag the sheet with the chart to the other book. When
you copy any sheet from one workbook to another all names in the original
workbook will come along. You may need to modify some of the names if they
reference the original workbook. You can do that quickly with the Edit,
Links command.

Cheers,
Shane Devenshire
Microsoft Excel MVP

 

[Mike C]

Hi Mike,

Open both files and tile them.  In the file with the defined names, hold
down the Ctrl key and drag the sheet with thechartto the other book.  When
you copy any sheet from one workbook to another all names in the original
workbook will come along.  You may need to modify some of the names if they
reference the original workbook.  You can do that quickly with the Edit,
Links command.

Cheers,
Shane Devenshire
Microsoft Excel MVP












- Show quoted text -

Great. Thanks SHane!