**In This Chapter**

Drawing circles with a scatter chart

Connecting data points to the chart axes or the origin

Creating frequency distributions and histograms

Plotting a normal curve

Calculating the area under a curve

Creating a box plot

Plotting 1– and 2–variable mathematical functions

Simulating a 3–D scatter plot

This chapter describes some charting techniques that may be useful for those who are mathematically or statistically inclined. The charts in this chapter use techniques that might not be obvious.

This section describes how to create a scatter chart that displays a perfect circle. To do so, you need two ranges, one for the *x* values and another for the *y* values. The number of data points in the series determines the smoothness of the circle.

The example in Figure 10-1 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 (on the Marker Line Style 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 10-1. This scatter chart uses 13 data points to define a circle.**

The examples in this section (plus a few additional examples) are available on the companion CD–ROM. The filename is `scatter chart circles.xlsx`

.

To draw a circle on a chart, ...

Start Free Trial

No credit card required