Microsoft Office Tutorials and References

In Depth Information

**Chart Examples**

Figure 17-15:
Using a surface chart to plot a function with two variables.

Figure 17-16 shows a general-purpose, two-variable plotting application, similar to the

singlevariable workbook described in the previous section. The data for the chart is a 25 x 25 data table

in range M7:AL32 (not shown in the figure). To use this application

1.
Enter a formula in cell B3. The formula should contain at least one x variable and at least

one y variable.

In the figure, the formula in cell B3 is

=SIN(x)*COS(y*x)

2.
Enter the minimum
x
value in cell B4 and the maximum
x
value in cell B5.

3.
Enter the minimum
y
value in cell B6 and the maximum y value in cell B7.