Microsoft Office Tutorials and References

In Depth Information

**Chart Examples**

After you perform these steps, the combo box displays the month names and places the index

number of the selected month into cell F1. The formulas in row 2 display the appropriate data,

which displays in the chart.

This example is available on the companion CD-ROM. The filename is
chart from

combo box.xlsx
.

Plotting mathematical functions

The examples in this section demonstrate how to plot mathematical functions that use one

variable (a 2-D line chart) and two variables (a 3-D surface chart). Some of the examples make use

of Excel’s Data Table feature, which enables you to evaluate a formula with varying input values.

A Data Table is not the same as a table, created using Insert

➜

Tables

➜

Table.

Plotting functions with one variable

An XY chart (also known as a scatter chart) is useful for plotting various mathematical and

trigonometric functions. For example, Figure 17-13 shows a plot of the SIN function. The chart plots
y

for values of
x (expressed in radians) from –5 to +5 in increments of 0.5. Each pair of
x and
y

values appears as a data point in the chart, and the points connect with a line.

Excel’s trigonometric functions use angles expressed in radians. To convert degrees to

radians, use the RADIANS function.

The function is expressed as

y = SIN(x)

The corresponding formula in cell B2 (which is copied to the cells below) is

=SIN(A2)