series name

[Andy]

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?

 

[Jon Peltier]

This page has a couple approaches which may be informative:

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

- Jon