Graph With 2 Sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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/
_______
 
Back
Top