Creating a Target or Goal Line by giving starting and ending goal values

[palmer41420]

I am creating a template/form for a table and a line chart that represents the data in the table. This is for progress monitoring in a school system. The table includes 37 weeks (columns). I want to add another row for a Goal line. The goal will increase each week (column). It would be really nice if there was a way to provide the week one goal in B11 and the week thirty-seven goal in AL11 then have excel auto-populate the values in between in equal increments. The reason for this is that the same table and line chart could then be used for a variety of progress monitoring tools with varying goals.

 

[gebobs]

If the lower goal range is in B11 and the upper goal range is in AL11, then enter the following in C11:

=B11+($AL11-$B11)/36

Copy and paste across from C11 to AK11. Do not copy it to AL11, your upper goal range, or you will have a circular reference error.

 

[palmer41420]

If the lower goal range is in B11 and the upper goal range is in AL11, then enter the following in C11:

=B11+($AL11-$B11)/36

Copy and paste across from C11 to AK11. Do not copy it to AL11, your upper goal range, or you will have a circular reference error.

THANK YOU! It works perfectly.