Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 29
Default Copying a sheet with a chart that uses Excel Names

Hi Group,

who knows the following XL-2003 effect and its solution:

An Excel sheet with a chart that uses Excel-names in the data-source. (e.g.
=Sheet1!Banana)
The names are located in the sheet, not in the workbook.
Then copy the sheet (inside or outside the workbook). Names are copied
automatically into the new sheet.
The chart in the copied sheet has no more names in its data-source, but the
basic values (e.g. ={160.200.240.320}).

XL-2007 has nearly the same effect: It changes the name into the cell
reference (Sheet1!$C$4:$C$7)

I am looking for a solution that evades any manual repair.
And without VBA!

Thanx, Holg.


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Copying a sheet with a chart that uses Excel Names

If you move the sheet into another workbook, the names in the chart series
formulas remain intact. You need to move the sheet, then if the sheet came
from a multiple sheet workbook, close the workbook without saving changes
and reopen it. If the source workbook had just the one sheet, Excel closes
it, so you can simply reopen it.

If it's something you'll use frequently, save the sheet with chart as a
template, and add the new sheet based on this template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Holger Gerths" wrote in message
...
Hi Group,

who knows the following XL-2003 effect and its solution:

An Excel sheet with a chart that uses Excel-names in the data-source.
(e.g. =Sheet1!Banana)
The names are located in the sheet, not in the workbook.
Then copy the sheet (inside or outside the workbook). Names are copied
automatically into the new sheet.
The chart in the copied sheet has no more names in its data-source, but
the basic values (e.g. ={160.200.240.320}).

XL-2007 has nearly the same effect: It changes the name into the cell
reference (Sheet1!$C$4:$C$7)

I am looking for a solution that evades any manual repair.
And without VBA!

Thanx, Holg.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 29
Default Copying a sheet with a chart that uses Excel Names

Great! Thanks a Lot!

"Jon Peltier" schrieb im Newsbeitrag
...
If you move the sheet into another workbook, the names in the chart series
formulas remain intact. You need to move the sheet, then if the sheet came
from a multiple sheet workbook, close the workbook without saving changes
and reopen it. If the source workbook had just the one sheet, Excel closes
it, so you can simply reopen it.

If it's something you'll use frequently, save the sheet with chart as a
template, and add the new sheet based on this template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Holger Gerths" wrote in message
...
Hi Group,

who knows the following XL-2003 effect and its solution:

An Excel sheet with a chart that uses Excel-names in the data-source.
(e.g. =Sheet1!Banana)
The names are located in the sheet, not in the workbook.
Then copy the sheet (inside or outside the workbook). Names are copied
automatically into the new sheet.
The chart in the copied sheet has no more names in its data-source, but
the basic values (e.g. ={160.200.240.320}).

XL-2007 has nearly the same effect: It changes the name into the cell
reference (Sheet1!$C$4:$C$7)

I am looking for a solution that evades any manual repair.
And without VBA!

Thanx, Holg.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying Excel column names and widths to a blank spreadsheet Louis B Moskowitz Excel Discussion (Misc queries) 1 June 7th 07 12:36 PM
Copying Excel Cells including Names Into Existing Spreadsheet MonkeyHanger Excel Worksheet Functions 3 March 28th 07 03:01 AM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Excel Discussion (Misc queries) 1 April 10th 06 12:57 PM
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Charts and Charting in Excel 1 April 10th 06 12:57 PM
Copying chart to another sheet Rebecca Excel Worksheet Functions 1 July 22nd 05 06:46 PM


All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"