Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Rise over Run Formula

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.
--
Cindy T
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default Rise over Run Formula

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cindy at PWIC" wrote in message
...
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.
--
Cindy T



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default Rise over Run Formula

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Cindy at PWIC" wrote:

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.
--
Cindy T

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to give 5%rise in a figure if it occurs b/wn 2 dates lwhat Excel Worksheet Functions 1 October 28th 05 11:21 AM
Transposing Sun and Moon rise and set times... [email protected] Excel Discussion (Misc queries) 4 September 22nd 05 04:20 PM
Transposing Sun and Moon rise and set times... [email protected] Excel Worksheet Functions 4 September 22nd 05 04:20 PM
Transposing Sun and Moon rise and set times... Greg Excel Discussion (Misc queries) 0 September 19th 05 08:05 PM
Transposing Sun and Moon rise and set times... Greg Excel Worksheet Functions 0 September 19th 05 08:05 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"