View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?