software

Dear charting experts!

I have created dynamic column chart according to Jon Peltier's
instructions on page

peltiertech.com/Excel/Charts/...umnChart1.html

Dynamic column chart works fine, I have only problem with copying it. I
copy the whole sheet along with the graph on it. Defined names change
as expected (from Sheet1!ChartValues to Sheet2!ChartValues), however
graph on the new sheet cell references no longer refer to defined names,
but to arrays of numbers. I have to correct these to make graph work
with new set of data. Is there any way to copy sheet and retain cell
references to defined names?

Thanks for the answer,

Marko Pinteric

I've brought this up with Microsoft, and the loss of link information is quot;by
designquot;. Huh! It only happens with sheet-level names, not workbook-level
names. Moving the sheet does not kill the links.

The thing to do is to save the workbook, move the sheet to a new workbook,
close the original workbook without saving changes, reopen the workbook, and
move the sheet into it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Marko Pintericquot; gt; wrote in message
...
gt;
gt; Dear charting experts!
gt;
gt; I have created dynamic column chart according to Jon Peltier's
gt; instructions on page
gt;
gt; peltiertech.com/Excel/Charts/...umnChart1.html
gt;
gt; Dynamic column chart works fine, I have only problem with copying it. I
gt; copy the whole sheet along with the graph on it. Defined names change as
gt; expected (from Sheet1!ChartValues to Sheet2!ChartValues), however graph on
gt; the new sheet cell references no longer refer to defined names, but to
gt; arrays of numbers. I have to correct these to make graph work with new
gt; set of data. Is there any way to copy sheet and retain cell references to
gt; defined names?
gt;
gt; Thanks for the answer,
gt;
gt; Marko Pinteric