| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
straight line equation
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
straight line equation
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line & Double Stacked Charts | Charts and Charting in Excel | |||
| Data showing incorrectly on line chart | Charts and Charting in Excel | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| Line Graph Help | Charts and Charting in Excel | |||
| equation for smoothed XY Scatter line | Charts and Charting in Excel | |||
Linear Mode
