adding data from multiple spreadsheets into one chart

[Marjory]

I need to put information from 4 different spreadsheets into one graph. Can
someone please help me?

 

[David Biddulph]

Produce a graph from your first spreadsheet.

Copy the relevant data range from the second spreadsheet, then select the
graph and edit/ paste special/ new series or new data points.
Similarly for the third and fourth sheets.

If you have difficulties getting exactly what you want that way, you can use
edit Source Data in the graph to add an extra series or to change the X or Y
data range for an existing sreries.

 

[Jon Peltier]

David's answer assumes that each series in the chart has its data well
contained onto a single worksheet. If your series requires data from more
than one worksheet, you need to set up a consolidated data range (which is
probably worth doing anyway). For details on using data from multiple sheets
in a chart, read this article:

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

- Jon