Can you combine data from 2 worksheets into 1 chart?

B

BP

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?
 

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

Similar Threads

Possible to Combine reports to's to a single box? 0
Abstracting Error Bar Data From Charts 3
Chart worksheet names keep resetting 0
Employee Schedule not plotting properly - chart type / data series not correct 0
help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0
superimposed 3-D stacked area charts 2
Convert Daily Data to Monthly Data 3
Data Limit on Bar Chart? 1

Top