The infinity is the point that never meets but in excel we have the limit of the data that is the maximum and minimum value that can be represented. For simplicity, We have assumed some table as shown below
|
1
|
Infinite
|
|
2
|
1.93
|
|
3
|
Infinite
|
|
4
|
3.16
|
|
5
|
Infinite
|
|
6
|
4.40
|
|
7
|
Infinite
|
|
8
|
5.64
|
Now if you will plot this on excel you will get a graph that can not read infinite. The excel will not be able to generate the graph properly.
So this infinity should be defined in some mathematical term. I have considered the value of tan 180o.
=tan(pi()*180/360)
Copy this value which is very large in the cells having infinite or place the formulae for +infinity.
Now using the scatter XY plot draw the curve as shown in the figure below:
Figure 1: selecting the graph from excel
The resultant graph is shown below
But it is not the actual picture the actual value have been reduced to very small value so we have to reduce the scale of the Y axis. To do this find the maximum and minimum values for the remaining values that may be suitable. We have selected max as 8 and min as 0.
Now format axis by clicking the axis as shown in the figure
Update the minimum and maximum to fixed values as shown in the figure
The resultant graph has been shown below
Here the line seems to be parallel and will meet at infinity.
No comments:
Post a Comment