#1   Report Post  
Posted to microsoft.public.excel.charting
KBA KBA is offline
external usenet poster
 
Posts: 2
Default Chart to new sheet

How can I move a chart from one sheet to another without the series refer to
the first sheet?


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Chart to new sheet

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

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


"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series refer
to
the first sheet?




  #3   Report Post  
Posted to microsoft.public.excel.charting
KBA KBA is offline
external usenet poster
 
Posts: 2
Default Chart to new sheet

So simpel :-) Thanks!

"Jon Peltier" skrev:

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

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


"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series refer
to
the first sheet?





  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Chart to new sheet

Everything's simple, when you know how!

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


"KBA" wrote in message
...
So simpel :-) Thanks!

"Jon Peltier" skrev:

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

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


"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series
refer
to
the first sheet?







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
Check Activesheet for chart sheet or work sheet NSK Charts and Charting in Excel 1 July 17th 07 09:00 PM
???Replicate a sheet but chart still link to original sheet Jaylin Charts and Charting in Excel 1 October 9th 06 03:14 PM
Moving Pivot Chart Fields on a chart sheet sherobot Charts and Charting in Excel 1 April 28th 06 10:08 PM
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


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

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

About Us

"It's about Microsoft Excel"