| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line charting the same series using data from multiple sheets?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line charting the same series using data from multiple sheets?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line chart, multiple series, data is inter-mixed | Charts and Charting in Excel | |||
| Excel Charting: Multiple data series on two axis instead of one? | Charts and Charting in Excel | |||
| Charting Multiple Series as one line | Charts and Charting in Excel | |||
| in charting, how do i select data ranges from multiple sheets, sa. | Charts and Charting in Excel | |||
| Charting series in different sheets (summarize) | Charts and Charting in Excel | |||
Linear Mode
