I would suggest consolidating / referencing the data from the different
worksheets into a single worksheet. Once that data is in a single worksheet,
you can create your chart.
You can use different worksheets - just my experience that it's easier to
put all of the data into one place.
It can generally be done. You may or may not need a consolidation sheet,
depending on how you want to chart the data, but even if you don't need one,
it's helpful to be able to see everything at once. Here's some guidelines:
