Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
Dynamic column chart - copying from Sheet to Sheet.
Dear charting experts! I have created dynamic column chart according to Jon Peltier's instructions on page http://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 |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
Dynamic column chart - copying from Sheet to Sheet.
I've brought this up with Microsoft, and the loss of link information is "by
design". 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 - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Marko Pinteric" wrote in message ... Dear charting experts! I have created dynamic column chart according to Jon Peltier's instructions on page http://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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trend chart with cummulative column | Charts and Charting in Excel | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |