Microsoft Office Tutorials and References

In Depth Information

Figure 17-18:
Creating a circle using an XY chart.

The ranges used in the chart appear in columns D and E. If you work in degrees, the formula in cell D2 is

=SIN(RADIANS(A2))

The formula in cell E2 is

=COS(RADIANS(A2))

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 Π di-

vided by (the number of data points minus 1, divided by 2).

Figure 17-19 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). A second series plots the

origin as a single data point. In the figure, the circle's origin is at 2,3 and it has a radius of 7.25.