Microsoft Office Tutorials and References
In Depth Information
XY Chart Variations
Figure 8-31: An XY chart that displays a map of California
The example in Figure 8-32 uses 13 points to create a circle with an origin of 0,0
and a radius of 1. This series uses the Smoothed line option (in the Patterns tab of
the Format Data Series dialog box). When this option is not set, the circle is not
very smooth, and its component lines are clearly visible.
Figure 8-32: This XY chart uses 13 data points to define a circle.
To draw a circle in a chart, generate a series of values such as the ones shown in
column A. The numeric series starts with 0 and has 30-degree increments. The
ranges that are used in the chart are in columns C and D. The formula in C2 is