Insert Rows Based on Cell Count

[PY_]

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.

[alansidman]

Look at this web site which describes how to develop dynamic ranges for charts.

http://peltiertech.com/Excel/Charts/Dynamics.html

Alan

[PY_]

I looked at that but got confused. Did some searching on the keywords and found a youtube link i found somewhat useful. http://www.youtube.com/watch?v=nz9Lc...eature=channel

This would be ok to use but my list needs to be able to add rows as needed based on the last cell containg data of my range. From what I understand, you have your row counts setup already for the dynamic list.