
IN THIS CHAPTER
Creating Charts That Show
Relationships
5
Comparing Two Variables on a Chart
The chart types discussed in this chapter are
unusual: Scatter, radar, bubble, and surface charts
are probably the least understood Excel charts.
Both scatter and bubble charts show the interplay
between two or three different variables. They
require a bit of care in setting up the data. A scatter
chart can help you to figure out whether there is a
correlation between two variables. A bubble chart
has the unique ability to provide data about a third
dimension. The first section in this chapter covers
the mechanics of creating scatter charts.
When you are thinking about ...