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...
A link to the helkp article would help a lot!
Can't you convert your range to a table? It will cause Excel to update the chart when data is added.
Can't you convert your range to a table? It will cause Excel to update the chart when data is added.
- 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.
