1 Reply Latest reply on Mar 31, 2016 2:29 PM by diego.medrano

    Create line w/ calculated start point and fixed end point

    Steve Amstutz

      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.