There does appear to be an issue with a blank Chart that is created, and then data from the Table is added-the Chart data doesn't track changes to the Table (it retains its initial range). select the Table data and then Insert is one answer here.
Two example Excel worksheets demonstrating these versions of dynamic charting are available as a free download.
By default, Microsoft Excel automatically updates a chart when you make a change to the chart data.
While automatic updating keeps a chart current, there may be times when you want to keep a snapshot of the data before an update.
That's because the chart, by default, references a specific data range, Dynamic Chart1: A1: E3. Now, start entering data for March and watch the chart automatically update!
We need to change that reference to the dynamic ranges we just created, as follows: Repeat the above process to update the remaining series to reflect their dynamic ranges: Dynamic Chart1! Just remember, you must enter data contiguously; you can't skip rows or columns.