Forum Discussion
Charts do not accept ranges with hash #
With latest Beta charts are dynamically changes if spill size is changed, similar to tables. In initial chart use B2:B10, whatever, not B2#. If spill will be changed on B2:C14, chart will be shown for the latest.
I am not sure I am entirely comfortable with that. It is undoubtedly clever to infer what the user would like (provided that is indeed what the user wanted) but that does not remove the need for Excel to accept correctly formulated dynamic array notation.
That's what we have. We can't use MyTable[MyColumn] in data validation list, conditional formatting, etc. but automatically expansion together with table and spill referenced directly is a good compromise.
I suppose it is something. Even there I would tend to take control of my own solution with
Name: MyValidationList Refers to: = MyTable[MyColumn] List Source: MyValidationListIt is simply that I detest the spreadsheet practice of direct cell referencing in its entirety!
The again, I was never happy to see a core dump that also uses direct memory addressing.
In many cases it looks like overcomplication. range=A1:A10 and SUM(range) is more complex than SUM(A1:A10)