Insert Rows Based on Cell Count

Is there a way to insert X number of rows based on the last cell containing data within a range?

My example starts with a chart that is 2 rows tall.

My range im watching is A20:G40

I want to expand the chart by X number of rows based on the last cell containing data within that range. In my case, it would be 9 rows.

Then I can just move the data into that chart after that. I am just unsure how to make the chart grow based on finding the last cell containg data of a range.