Microsoft Office Tutorials and References
In Depth Information
Plotting two-variable mathematical functions
To create this chart, follow these steps:
1. Select A1:B22.
2. Choose Insert
Charts
Scatter
Scatter with Straight Lines and Markers.
3. Choose a chart layout that gives you the look you like and then fine-tune it.
Change the values in column A to plot the function for different values of x. And, of course, you
can use any single-variable formula you like in column B. Here are a few examples that make
interesting plots:
=SIN(PI()*A2)*(PI()*A2)
=SIN(A2)/A2
=SIN(A2^3)*COS(A2^2)
=NORMDIST(A2,0,1,FALSE)
For more accurate charts, increase the number of plotted values and make the increments in
column A smaller.
Plotting two-variable mathematical functions
You also can plot functions that use two variables. For example, the following function calculates
a value of z for various values of two variables (x and y):
z = SIN(x)*COS(y)
Figure 140-2 shows a surface chart that plots the value of z for 21 x values ranging from –3 to 0
and for 21 y values ranging from 2 to 5. Both x and y use an increment of 0.15.
The x values are in A2:A22, and the y values are in B1:V1. The formula in cell B2, which is copied to
the other cells in the table, is
= SIN($A2)*COS(B$1)
To create this chart, follow these steps:
1. Select A1:V22.
2. Choose Insert
Charts
Other Charts
3-D Surface.
3. Choose a chart layout that gives you the look you like, and then fine-tune it.
 
Search JabSto ::




Custom Search