Dashboard Line Chart - Automatically Update


I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date.

I have a Data Shuttle that updates the source sheet each Friday with a new data point.

Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet? Example below shows how a new data point of "41" was added on 8/24/22 but you can see that the chart area only goes down to row 6. Is there a way to select the entire column and have it update dynamically?