adding data from multiple spreadsheets into one chart
 

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

adding data from multiple spreadsheets into one chart
 

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.
--
David Biddulph

"Marjory" wrote in message
...
I need to put information from 4 different spreadsheets into one graph. Can
someone please help me?

adding data from multiple spreadsheets into one chart
 

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/ChartsH...iffSheets.html

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


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

"Marjory" wrote in message
...
I need to put information from 4 different spreadsheets into one graph.
Can
someone please help me?