Last Update: 1/17/2018
You can easily create a graph with multiple plots from different worksheets, utilizing the Plot Setup dialog. Your XY data can be located in any worksheet, but the X column and Y column must be in the same worksheet.
There are different ways:
Please view this tutorial:
Graphing Data from Multiple Sheets
Keywords:setup, layer, contents, multi