Microsoft Office Tutorials and References
In Depth Information
XY (scatter) charts
XY (scatter) charts
Another common chart type is XY charts (also known as scattergrams or scatter
plots ). An XY chart differs from most other chart types in that both axes display
values (there is no category axis in an XY chart).
This type of chart often is used to show the relationship between two variables.
Figure 2-14 shows an example of an XY chart that plots the relationship between
sales calls (horizontal axis) and actual sales (vertical axis). The chart shows that
these two variables are positively related: Months in which more calls were made
typically had higher sales volumes.
Although these data points correspond to time, it’s important to understand
that the chart does not convey any time-related information. In other words,
the data points are plotted based only on their two values.
Figure 2-14: An XY chart shows the relationship between two variables.
Adding a trend line to this chart would assist in conveying the fact that the
variables are positively correlated. See Chapter 5 for details on trend lines.
Table 2-6 lists Excel’s five XY (Scatter) chart subtypes.
Search JabSto ::

Custom Search