Microsoft Office Tutorials and References
In Depth Information
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
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.