Statistical Analysis with Excel For Dummies, 5th Edition

Appendix C

More on Excel Graphics

IN THIS Appendix

Creating bubbles

Taking stock

Building boxes and whiskers

Adding a dimension to maps

In Chapter 3, I describe the graphs (excuse me, charts) you’ll probably use most frequently. In this appendix, I delve into Excel charts that are a bit more esoteric.

Tasting the Bubbly

A bubble chart is a way of visualizing three dimensions in a two-dimensional chart. Each data point appears as a circle, or “bubble,” in the chart. The bubble’s position along the x- and y-axes represents two dimensions, and the size of the bubble represents the third.

Figure C-1 shows data I use in Chapter 14 when I discuss multiple regression. The data are for the 20 students listed in Column A. Column B shows SAT data (under the old scoring system), Column C shows the high school average, and Column D shows college GPA.

In the accompanying bubble chart, SAT is on the x-axis, high school average is on the y-axis, and the width of the bubbles represents college GPA.

I select cells B2 through D21, and the bubble chart is the sixth choice under Recommended Charts. ...