Microsoft Office Tutorials and References
In Depth Information
Drawing a circle around data points
The formula in D2 is
The formulas in C2 and D2 are copied down to subsequent rows.
To plot a circle with more data points, you need to adjust the increment
value in column A (the final value should always be 360). The increment is
360 divided by the number of data points minus 1. The more data points
used, the smoother the circle.
Drawing a circle around data points
The example in this section, which builds on the previous example, demonstrates how
to use an XY chart series to draw circles around data points in a chart. Figure 8-33
shows an XY chart that contains four series: the first series (range A2:B4) plots the
three data points (as markers only; no line). Three additional series (ranges B9:C21,
D9:E21, and F9:G21) plot a circle around each point (as lines, not markers).
Figure 8-33: Using XY series to draw circles around data points
The three circle series use formulas similar to those described in the previous
section, but these formulas allow for a specific origin and radius. The radius of each
circle is defined by the entries in row 7.
Search JabSto ::

Custom Search