Chart from two different worksheets

[lisa]

I was wondering if I could create graphs in excel with data on two different worksheets in the same excel spreadsheet? And if so, how would I go about selecting the data from both worksheets?

 

[Jon Peltier]

Lisa -

This web page tells about using data from different worksheets in the
same chart:

http://peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html

To select the data, right click on the chart, select Source Data from
the pop up menu, and click on the Series tab. Click in one of the data
selection boxes, then use the Windows menu to select a different
workbook or the sheet tabs to select a different worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[lisa]

Thank you for the reply, that really helped me out.