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




Custom Search