Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Chapter 3 Working with Charts 115

The area of each bubble in the plot is proportional to the percentage of in-
coming freshman-athletes who graduated in the top 25% of their class. You
can change this so that the width of each bubble is proportional to that value.
In some situations, this works better in displaying differences between one
data point and another. You can also make the bubbles smaller so that there
is less overlap. Investigate the effect of changing the bubble symbol size on
the appearance of your chart.

To change the bubble size:

1 Click one of the bubbles in the chart to select all of the bubble
symbols again.
2 Return to the Format Data series dialog box by clicking the Format
tab from the Chart Tools ribbon and then click the Format Selection
button from the Current Selection group.
3 If necessary click the Series Options tab and then click the Width
of bubbles option button and enter 50 in the Scale bubble size to
input box. This will reduce the width of the bubbles to 50% of their
default size (see Figure 3-28).

Figure 3-27
Revised
bubble plot

Free download pdf