straight line equation

[Guest]

I want to display a long term award in a graph

Basically the award plan pays as follows

100% of target achievement returns 40% growth on the award
150% of target achievement returns 140% growth on the award (growth is
capped at 150% of target achievment)

I want to display linear growth between the 2 points 40% growth and 140%
growth

thanks

 

[Bernard Liengme]

In A1 enter 100%, in A2 enter !50%
In B1 enter 40% and in B2 enter 140%
Select A1:B2 and make an XY chart (NOT a Line chart)
Make sure in the Chart Wizard that it uses data in Columns
best wishes