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.

--
John Mansfield
http://cellmatrix.net





"Rose" wrote:

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