O'Reilly logo

Excel® 2007 Charts by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Mathematical and Statistical Charting Techniques

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.

Drawing a Circle with an XY Series

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.

This scatter chart uses 13 data points to define a circle.

Figure 10-1. This scatter chart uses 13 data points to define a circle.

Note

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required