Forum Discussion
Solved
Does newer versions of Excel allow structured references to table columns for chart creation?
I understand this was not possible in earlier versions of Excel. Just wondering if this has been addressed since then. So I would like to use a structured reference when creating the chart to a table...
No, when you enter a structured reference in the Select Data dialog, Excel will convert it to a cell reference. But if you create a chart from a table, the source range will expand and contract automatically with the table.
No, when you enter a structured reference in the Select Data dialog, Excel will convert it to a cell reference. But if you create a chart from a table, the source range will expand and contract automatically with the table.
HansVogelaar thanks, that seems to do the trick!