View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default help with creating function and figuring out formula

It looks like your formula for Y is 10^((X-10)/10)
Note also that your value for X=0 should presumably be 0.1, not 0.
If you want the graph as a straight line, use a log scale for the Y axis.
--
David Biddulph

"monkeytrader" wrote in message
...
i hope someone can help. i am given two sets of data that i want to
graph a positive sloping straight line, but don't know how to set it
up, nor do i know what the equation is to figure out what any other
data point would be on the line.

the x values: the y values:

10 1
20 10 (1*10)
30 100 (10*10)
40 1000 (100*10)
50 10000 (1000*10)
etc... etc...

i need to graph these points so it makes a positive sloping straight
line, whe
(0,0) is the first point, (10,1) is the second point, (20,10) the
third point, (30,100) the next point, etc.

also, i need to know the equation to plot numbers that would fall in
between the points ( i.e.: what would the y value be for x = 27).

sorry, but this seems like a lot of work. i hope someone out there can
help. thanks again in advance.