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.
- It doesn't work in all cases.
Try putting number in cell A1 (use 50).
Use two sequences in cell B1 and C1 as =SEQUENCE(A1,1,5,5) and =SEQUENCE(A1,1,17,9). Build a chart using B1:B50 and C1:C50.
Now change cell A1 to 100, which will make both the sequences to generate 100 elements. The chart will still use only 50 elements.In my case it works
Even if you are on Beta channel new functionality is deployed gradually, hope will come soon.
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.
