Excel 2010 Bible

Chapter 18: Getting Started Making Charts

433

FIGURE 18.32

A surface chart.

Bubble

Think of a bubble chart as an XY chart that can display an additional data series, which is repre-

sented by the size of the bubbles. As with an XY chart, both axes are value axes (there is no cate-

gory axis). Bubble charts are listed in the Other Charts category.

Figure 18.33 shows an example of a bubble chart that depicts the results of a weight-loss program.

The horizontal value axis represents the original weight, the vertical value axis shows the number

of weeks in the program, and the size of the bubbles represents the amount of weight lost.

On the CD
A workbook that contains the charts in this section is available on the companion CD-ROM. The file is named
bubble charts.xlsx.

Figure 18.34 shows another bubble chart, made up of nine series that represent mouse face parts.

The size and position of each bubble required some experimentation.

Stock

Stock charts are most useful for displaying stock-market information. These charts require three to

five data series, depending on the subtype. This chart type is listed in the Other Charts category.