Excel 2010 Bible

Part III: Creating Charts and Graphics

426

FIGURE 18.22

A bar of pie chart that shows detail for one of the pie slices.

XY (scatter)

Another common chart type is an XY chart (also known as scattergrams or scatter plots). An XY

chart differs from most other chart types in that both axes display values. (An XY chart has no cate-

gory axis.)

This type of chart often is used to show the relationship between two variables. Figure 18.23 shows an

example of an XY chart that plots the relationship between sales calls made (horizontal axis) and sales

(vertical axis). Each point in the chart represents one month. The chart shows that these two variables

are positively related: Months in which more calls were made typically had higher sales volumes.

FIGURE 18.23

An XY chart shows the relationship between two variables.