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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"WaqB" wrote in message
...
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