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'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:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
