Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to give 5%rise in a figure if it occurs b/wn 2 dates | Excel Worksheet Functions | |||
Transposing Sun and Moon rise and set times... | Excel Discussion (Misc queries) | |||
Transposing Sun and Moon rise and set times... | Excel Worksheet Functions | |||
Transposing Sun and Moon rise and set times... | Excel Discussion (Misc queries) | |||
Transposing Sun and Moon rise and set times... | Excel Worksheet Functions |