Is it possible to redirect the data source series of a plot to a cell
location so that it can be manipulated? For example, the current data
series is ='Spending Data'!$A$32:$A$43. I would like to be able to
adjust the series by entering a value in a cell. For example, using
the existing range as a baseline, entering a "1" in the magic cell
would change the series to ='Spending Data'!$A$33:$A$44. I have tried
using INDIRECT, but either I don't understand how to correctly use it,
or its use in a graph data series assignment, or both.

A pointer to an online example would be great.

Thanks!

Don