Forum Discussion
Charts do not accept ranges with hash #
I don't seem to use the dynamic ranges with #, which works fine in formula. Is this a known issue in charts? Is there any workaround? To reproduce the problem, we create two sequences in A2 an...
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.
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.