When we plot a chart in Google Sheets, we should specify a range. Suppose I created a chart using the range A1: B2. Later I’ve added one more row to my data. Now the range is A1: B3. If the chart can automatically grow based on this new row, we can call this a dynamic range.
For More Information Please Refer: