Graph With 2 Sources

[Guest]

Is there a way to create a graph which gets it's source data from 2+ worksheets? Each worksheet charts the same kind of data. The x-axis length does vary but I don't mind manually entering the cell references.

 

[Jon Peltier]

Look at Charting Data From Different Sheets:

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

You can't put data from different sheets into the values for a single
series. My question for you: if you don't mind manually entering cell
references, why haven't you just linked cells in a third worksheet to
the cells in the first two, and plotted off the third?

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