Microsoft Office Tutorials and References

In Depth Information

**Chart Examples**

Figure 17-14:
A general-purpose, single-variable plotting workbook.

Plotting functions with two variables

The preceding section describes how to plot functions that use a single variable (
x). 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 17-15 shows a surface chart that plots the value of
z
for 21
x
values ranging from 2 to 5 (in

0.15 increments) and for 21
y
values ranging from –3 to 0 (also in 0.15 increments).