I am reporting survey data in a line graph. Need to provide a calculated line that depicts target for growth to a desired point in the future. I need this growth target line to begin at the Year1 variable data point and end at a fixed target point in Year5. This line will should be based solely on the Year1 data and remain fixed even with the addition of data from future years (Year2, Year3 . . . ).
Is this possible?
The attached workbook (v9.2) depicts a growth target line that I manually calculated and entered to provide an example.