PC Review


Reply
Thread Tools Rate Thread

Chart across multiple worksheets

 
 
cathcarr
Guest
Posts: n/a
 
      9th Jun 2004
I have a large set of data in excel that is used to populate a chart.
new column is added to the data every week, and the graph is updated.
The problem is, I have filled up to column IV in the worksheet and ca
not add any more columns. Therefore I have started to add the new dat
into a new sheet.
I now need the graph to show data from the old sheet and the new sheet
Is this possible?
Thanks!
C

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      9th Jun 2004
This page has some information about charting data from multiple sheets:

http://peltiertech.com/Excel/ChartsH...entSheets.html

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

cathcarr < wrote:

> I have a large set of data in excel that is used to populate a chart. A
> new column is added to the data every week, and the graph is updated.
> The problem is, I have filled up to column IV in the worksheet and can
> not add any more columns. Therefore I have started to add the new data
> into a new sheet.
> I now need the graph to show data from the old sheet and the new sheet.
> Is this possible?
> Thanks!
> C.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up one chart for multiple worksheets? =?Utf-8?B?TWltaQ==?= Microsoft Excel Charting 2 24th Aug 2006 01:30 PM
Creating a chart from multiple worksheets =?Utf-8?B?bGlzc2Fza2k=?= Microsoft Excel Charting 5 28th Jul 2006 02:27 PM
Line chart from multiple worksheets =?Utf-8?B?UGF1bCBCLg==?= Microsoft Excel Charting 2 21st Sep 2005 11:46 PM
How do I chart multiple worksheets ? =?Utf-8?B?ZmxhbWluZ29sZWdz?= Microsoft Excel Charting 1 23rd Aug 2004 11:55 PM
Chart with data from multiple worksheets surftesh Microsoft Excel Misc 1 19th Sep 2003 10:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:57 PM.