Microsoft Office Tutorials and References

In Depth Information

**PLOTTING FUNCTIONS WITH ONE VARIABLE**

PLOTTING FUNCTIONS WITH ONE VARIABLE

An XY chart is useful for plotting various mathematical and trigonometric

functions. For example, Figure 8-50 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.

The function is expressed as

y = SIN(x)

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

=SIN(A2)

Figure 8-50: This chart plots the SIN(x).

Figure 8-51 shows a general-purpose, single-variable plotting application. The

data for the chart is calculated by a Data Table in columns J:K and is 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. In the figure, the formula in cell B3 is

=SIN(PI()*x)*(PI()*x)

2.
Enter the minimum value for x in cell B4.

3.
Enter the maximum value for x in cell B5.