Graphing a series from separate spreadsheets

[4hunters]

How do i graph data in a single series for a line graph from spearate spreadsheets in Excel 2007? (i.e one spreadsheet is data from 2009, next is 2010, next is 2011- same data- but the graph is showing the data in a line graph for the whole time fram 2009-2011). It isn't letting me pull the data, and it seems like it should.

 

[VoG]

You should be able to chart the first series, copy the second series, activate the chart, right click the series on the chart, tick New Values and click OK. Repeat as needed.

 

[4hunters]

Can you elaborate further, because I am confused. What do you mean copy. i am using the chart wizard, and when I am trying to add the other spreadsheet it doesnt work.