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

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?

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/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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