A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

copying charts into new sheets, data is pulled from old sheet



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2006, 03:16 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default copying charts into new sheets, data is pulled from old sheet

i make a sheet with a load of data and some graphs,
then i want to copy the whole thing into a new sheet to process some similar
but different data,
all the cell references translate cleanly, and refer to the new sheet
however, the graphs reflec tthe previous sheets ranges and data.

how can i copy the graphs so they refer to cells on the new sheet?

btw i know excel pretty well, and i could go through and drag new data on,
but i would like about 30 graphs per sheet, so its tedious.
thanks
  #2  
Old February 24th, 2006, 03:59 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default copying charts into new sheets, data is pulled from old sheet

instead of copying just the data, use the Move or Copy Sheet option under
Edit and copy the whole sheet.
--
mam


"kstevens" wrote:

i make a sheet with a load of data and some graphs,
then i want to copy the whole thing into a new sheet to process some similar
but different data,
all the cell references translate cleanly, and refer to the new sheet
however, the graphs reflec tthe previous sheets ranges and data.

how can i copy the graphs so they refer to cells on the new sheet?

btw i know excel pretty well, and i could go through and drag new data on,
but i would like about 30 graphs per sheet, so its tedious.
thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Worksheet Functions 7 September 3rd, 2005 03:47 PM
Multiple worksheet queries liam Worksheet Functions 3 February 16th, 2005 07:52 PM
(¯`·._.·[ Extract Data From Multiple Sheets ]·._.·´¯) hyperdreamz General Discussion 1 September 29th, 2004 04:03 PM
How can I creat a combined sheet using the data in other sheets? arbin General Discussion 1 August 18th, 2004 12:54 PM
Help - Linking sheets and data from Sheet 1 to blank worksheet Bimmy Worksheet Functions 1 March 11th, 2004 07:51 AM


All times are GMT +1. The time now is 01:24 PM.


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