structured references in series formula?

[pcuaron]

Hello. I've just tried to use a structured reference (eg sheetname!tablename[columnname]) inside a SERIES formula without luck, the instant I press enter excel replaces the structured reference with an absolute reference (eg sheetname!$a$1:$a$10). Trying to use INDIRECT doesn't help either, as excel shows a "that function is not valid msgbox". I'm trying to find a simpler way to do dynamic named ranges. Does anyone know some trick to make this work?

Thanks for your time!

 

[Andrew Poulsom]

I think you will find that the chart will update when the size of the table changes even though the reference has been changed. See:

http://www.excelforum.com/excel-cha...-series-and-structured-references-2007-a.html

 

[pcuaron]

Re: structured references in series formula? [SOLVED]

I think you will find that the chart will update when the size of the table changes even though the reference has been changed. See:

http://www.excelforum.com/excel-cha...-series-and-structured-references-2007-a.html

Amazing how this stuff gets past MS QA. Thanks for the link, didn't realize it by myself.