Yes I did see your file and tested it.

Did you try what I suggested?

For me turning the data into a table linked the chart directly to the data.
Adding new information in row 5 caused the chart to update automatically.