Forum Discussion
How do I use defined names to automatically update a chart range in Excel 2016
Microsoft Support Help Article 183446 (How to use defined names to automatically update a chart range in Excel) does not state it applies to Excel 2016. I have though tried using the instructions gi...
https://support.microsoft.com/en-gb/help/183446/how-to-use-defined-names-to-automatically-update-a-chart-range-in-exce
You should be able to achieve exactly that, just by formatting your data table as table (Home, Format as table). No dynamic range names required.
I agree. Using a Table within the Excel sheet in this instance is by far the easiest technique to use, the reference method is a lot easier too: "=<table_name>[<column_name>]". The chart now automatically updates as soon as the table is extended/shrunk in rows.
Many thanks for the suggestion.