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.