Rise over Run Formula

[Cindy at PWIC]

I need to create a chart with rise over run formula.

EX: I have a distance of 100 feet with an height of 8 feet, how high is
every inch or every foot inbetween? Any ideas? Thanks in advance.

 

[Bernard Liengme]

If you want to plot the data in a chart:
In A1 type: Distance
In B1 type : Height
In A2 and B2 type: 0
In A3 type: 100
In B3 type: 8
Select A1:B3 and (in Classical Excel - pre-2007) use the chart wizard to
make an XY chart
In Excel 2007 use Insert | Chart | XX


If by 'chart" you mean a table
In A1 type: Distance
In B1 type : Height
In A2 and B2 type: 0
In A3 type: 1
In B3 type: =(100/8)*A3
In A4 type: 4
In B4 type =(100/8)*A4
Select A3:B4 and drag the fill handle (small solid square in lower right
corner of select range down as far as you wish
You could use this table to make an XY chart

best wishes

 

[Shane Devenshire]

Hi,

In cell A1 enter 8 in B1 100. If you want to plot for every foot enter
7 in A2 and in B2 enter

=A2/A1*B1

Highlight A1:A2 and fill it down. Select B2 and fill it down.

If you want to plot by inches then in A2 enter

=A1-1/12

and copy it down. The B2 formula remains the same, just copy it further down.