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...
This is a known limitation. As a workaround, create a named range X_Values that refers to =$A$2#, and another named range Y_Values that refers to =$B$2#.
You can use X_Values and Y_Values in the Select Data dialog.
See the attached demo workbook.