Line charting the same series using data from multiple sheets?

A

Aaron

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
 
J

Jon Peltier

Use formulas in a summary sheet to link to the separate data sheets,
then plot the summarized data.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top