Can the data range in a chart contain a formula?

[David Wainwright]

I want the data range in a chart to change depending on the value of a cell
in a worksheet. For example...

If A1=10, I want the data range to be B1:B10.
If A1=20, I want the data range to be B1:B20.

Does anyone know how I can achieve this?

Thanks in advance,
David.

 

[David Wainwright]

Thanks! It took me a while but I eventually got it working.

The OFFSET function is the key, it provides the mechanism to specify a
configurable range via a named formula. Getting the correct apostrophes in
the right places was a bit tricky as well.

Thanks,
David.