Chart across multiple worksheets

's Computer Specifications

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

's Computer Specifications

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/
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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