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...
Just an added thought based on HansVogelaar 's strategy. If you use sheet-local names rather than workbook scoped names, the fully qualified names used by the chart engine to address data can be shorter and more meaningful. For example, if the sheet tab shows "cht", the series would read
=SERIES(,cht!x,cht!y,2)