spacing numbers in 1st column by inch intervals of 2nd column

E

eganders

I have an Excel chart of two columns of numbers. One column has
angular values (from 1 degree to 45 degrees) that are to be spaced by
intervals specified by numbers in the second column (1.3 inches to
14.1 inches).

Is there a program that will place numbers specified in the first
column by the intervals spcified in the second column? For example,
say that the column of numbers were:
deg inches
1 1.3
10 4.1
15 5.7
20 6.3

Is there a program that will place the 1 degree at 1.3 inches above a
reference point in a column, 10 degrees at 4.1 inches above a reference
point, 15 degrees 5.7 inches above a reference point and so on?

15 (---------------5.7 inches)



10 (----------------4.1 inches)





1 (-----------------1.3 inches)

---------------------------------------0 inches
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbered scale spaced by interval defined by nos in column 5
placing numbers in one column at intervals of 2nd 0
Can Visio place numbers at specified intervals? 1
Creating reference numbers from column of data 3
Formula to Identify Col Data-Pairs that Differ by 2*pi 2
How to use VLookup with a range of numbers? 3
conditional formula - little bit of twist for my report. 2
Count Intervals of Filtered TEXT values in Column and Return Count across a Row 9

Top