Prev: spreadsheet problem
Next: Excel 2007: Saving a file with a Macro
From: Aaron on 28 Apr 2010 09:36
I have data for each day of the week per sheet for four weeks, ie 4 sheets.
I'd like to line chart this data on the same series using the data from each
of the four sheets continuously.
eg. graph (sheet 1) mon, tue, wed, thur, fri, (sheet 2) mon, tue, wed, thu,
fri, (sheet 3) mon, tue, wed, thu, fri, (sheet 4) mon, tue, wed, thu, fri
on the same series

Please help
Thanks,
Aaron
From: Jon Peltier on 29 Apr 2010 17:10
Use formulas in a summary sheet to link to the separate data sheets,
then plot the summarized data.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/28/2010 9:36 AM, Aaron wrote:
> I have data for each day of the week per sheet for four weeks, ie 4 sheets.
> I'd like to line chart this data on the same series using the data from each
> of the four sheets continuously.
> eg. graph (sheet 1) mon, tue, wed, thur, fri, (sheet 2) mon, tue, wed, thu,
> fri, (sheet 3) mon, tue, wed, thu, fri, (sheet 4) mon, tue, wed, thu, fri
> on the same series
>
> Please help
> Thanks,
> Aaron
 | 
Pages: 1
Prev: spreadsheet problem
Next: Excel 2007: Saving a file with a Macro