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.