Microsoft Office Tutorials and References

In Depth Information

**Chart Examples**

Figure 17-16:
A general-purpose, two-variable plotting workbook.

The formula in cell B3 displays the value of z for the minimum values of
x
and
The data table
y.

evaluates the formula for 25 equally spaced values of
x
and 25 equally spaced values of
These
y.

values are plotted in the surface chart.

This workbook, which is available on the companion CD-ROM, contains simple macros

that enable you to easily change the rotation and elevation of the chart by using scroll

bars. The file is named
function plot 3D.xlsm
.