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