Microsoft Office Tutorials and References
In Depth Information
Chart Examples
If you work in radians, use this formula in cell D2:
=SIN(A2)
And use this formula in cell E2:
=COS(A2)
The formulas in cells D2 and E2 are copied down to subsequent rows.
To plot a circle with more data points, you need to adjust the increment value and the number of
data points in column A (or column B if working in radians). The final value should be the same as
those shown in row 14. In degrees, the increment is 360 divided by the number of data points
minus 1. In radians, the increment is
Π
divided by the number of data points minus 1, divided by 2.
Figure 17-18 shows a general circle plotting application that uses 37 data points. In range
H27:H29, you can specify the x origin, the y origin, and the radius for the circle (these are named
cells). In the figure, the circle’s origin is at 1,3 and it has a radius of 7.25.
The formula in cell D2 is
=(SIN(RADIANS(A2))*radius)+x_origin
The formula in cell E2 is
=(COS(RADIANS(A2))*radius)+y_origin
This example, named plot circles.xlsx , is available on the companion CD-ROM.
 
Search JabSto ::




Custom Search