Microsoft Office Tutorials and References

In Depth Information

**Fun with Trigonometry**

Figure 12-3: Spin the wheel — uh, doughnut chart.

Fun with Trigonometry

Charts that plot data generated by trigonometric functions can be stunning. Even if

you don’t know the difference between a SIN function and a stop sign, you can still

create some incredible designs.

A simple sine versus cosine plot

I start with a simple example. The XY chart in Figure 12-4 plots the data in column

B against the data in column C (the chart axes are hidden). Column A contains

formulas that generate a sequence of numbers, using the increment value in cell A1.

The formula in B3, which is copied to 99 cells below it, is

=SIN(A3)

The formula in C3, which is also copied to the cells below, is

=COS(A3)

The chart will look dramatically different with various increment values in cell A1.

Figure 12-5 shows the chart when cell A1 contains 2.1. To display various

geometric shapes, use a formula in the form of the following, varying the value of n. For

example, when n is 4, the chart displays an octagon.

=PI()/n