Updating Charts with Dynamic Named Range

There is an Excel file that teaches how to perform the Updating Charts with Dynamic Named Range operation.

Excel Spreadsheet for Updating Charts with Dynamic Named Range

The chart source is automatically expanded using dynamic named ranges in this file. Additionally, OFFSET and COUNTA functions are used together in defining the dynamic range. Thus, chart updates occur automatically as new data is added. For this reason, it serves as an ideal method for users working with continuously updated data. Therefore, the need for manual chart updates is eliminated.

Hope it is useful.