If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you combine data from 2 worksheets into 1 chart?
My son is working on a science project. He had to track the temperature and
precipitation levels in Daytona Beach for 9 years. I put the data in 2 worksheets, one for temperature and one for precipitation. He now has to make charts for the data. We've done the 2 separate charts but now we need to make 1 chart showing all the data. Is there a way to take the data from the 2 separate worksheets and put it into 1 chart? |
#2
|
|||
|
|||
Can you combine data from 2 worksheets into 1 chart?
http://peltiertech.com/Excel/ChartsH...iffSheets.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BP wrote: My son is working on a science project. He had to track the temperature and precipitation levels in Daytona Beach for 9 years. I put the data in 2 worksheets, one for temperature and one for precipitation. He now has to make charts for the data. We've done the 2 separate charts but now we need to make 1 chart showing all the data. Is there a way to take the data from the 2 separate worksheets and put it into 1 chart? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I chart the same data cell on a range of worksheets? | Keith | Charts and Charting | 1 | May 7th, 2005 03:55 PM |
Help making a chart that doesn't graph cells without data? | Filtration Guy | General Discussion | 0 | March 22nd, 2005 09:21 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Chart Data Table, Data Range, etc. do not update on Chart | RichardS | Charts and Charting | 3 | December 17th, 2003 05:56 PM |