Hi
I have a chart that will shrink and grow in width between 3-12 columns
My problem is how to dynamically allow this
I have a formula which works out the address of the last cell in the range which appears to be working and I have concatenated that with some fixed cell bits so I end up with a named cell called "LastProd" containing the value =Sheet1$D$34:$M$35
In my sheet I have tried to refer to it in Values: as INDIRECT(LastProd) but excel does not like that.
any ideas
I have a chart that will shrink and grow in width between 3-12 columns
My problem is how to dynamically allow this
I have a formula which works out the address of the last cell in the range which appears to be working and I have concatenated that with some fixed cell bits so I end up with a named cell called "LastProd" containing the value =Sheet1$D$34:$M$35
In my sheet I have tried to refer to it in Values: as INDIRECT(LastProd) but excel does not like that.
any ideas
