Creating a chart using data from multiple worksheets

[Rose]

I am trying to create a chart using data from multiple worksheets within one
workbook. Does anyone have experience in doing this?

 

[John Mansfield]

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.

 

[Jon Peltier]

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:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon