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.
Search JabSto ::

Custom Search