This page has a couple approaches which may be informative:
http://peltiertech.com/Excel/ChartsH...iffSheets.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Andy" wrote in message
...
I have a chart setup that refers to sheet w/ data. I would like to enter
the
name of the sheet (in a cell) that would update the sheet name in the
chart
series/data range so that my chart can view multiple data sets on
different
sheets. Is this possible and how?