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
The formula in C3, which is also copied to the cells below, is
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.
Search JabSto ::

Custom Search