Building Math Graphs in Excel

[RussianBoy]

Hi. During the process of building different math graphs, I was
confronted with some difficulties. The task is to build a graph of math
function *y=1/x*, the graph of this function represents *hyperbola*. I
cant understand how to build it. It seems to me that there is no
*asymptotes* in Excel. And do u have any ideas how to build it in
Excel?

P.S. Sorry if my English is bad.

 

[Jerome Ranch]

I must be missing something in your question...
In A1..A10 etc downward put numbers 1,2,3,4,5,6 etc
In B2..B10 etc place the formula =1/A1
The plot it out as scatter chart
Works fine

Is this what you are trying to to?

Jerry

 

[RussianBoy]

Certainly, but we should not forget that we cant divide on zero. So.. if
we take values only begining from *1* - it will be only one branch of
hyperbola. And my task is to build the whole function (to paint two
braches of the initial function). So if we take values from *-10* to
*10*, for example, (of course excepting the value *0*), the two braches
of the hyperbola will be united with each other by a straight line. The
problem is in that thing.

 

[Jerome Ranch]

Yep I see the problem
You could plot it as two separate curves on the same graph (with
different limits of x)..buts that cheating

Jerry

 

[RussianBoy]

Hm.. but how can I do it? Can u show the order of actions by wich its
possible to plot it as two separate curves on the same graph? How can I
realize it? Explain it, please.

 

[Dana DeLouis]

As a workaround, perhaps you could just Delete the cell that has the =1/0
formula.
This will cause a break in the data, and will cause the line near the
discontinuity to disappear.

 

[Jerome Ranch]

Select the line
right click> source data. make the two charts two different series
with different x and y values

I FW you an email with an example
Jerry

 

[RussianBoy]

Thank u very much for the help.
Russia won't forget u. *