• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Scatter (XY) Charts

Scatter charts are used to show correlations between two sets of values, one on the Y-axis and one on the X-axis. While you can represent time on the X-axis, the line chart is somewhat better designed for that purpose in most cases. (The exception is when you need to show time as a value-in numbers of seconds or minutes, for example-and you may want to use a logarithmic scale.) Scatter charts come in five subtypes, as outlined in Table 12.4.

Table 12.4. Scatter Charts in Excel 97
SubtypeDescription
ScatterThe standard Scatter chart uses data markers only to show where data values intersect between the X- and Y-axes. Figure 12.15 shows a standard Scatter chart.
Scatter with Data Points Connected by Smooth LinesThis subtype connects the data points for each series with smoothed lines between data markers. You can also choose this variant without data markers, where only lines are shown.
Scatter with Data Points Connected by LinesUse this subtype as an alternative to the line chart when you need to chart values along the X-axis. An example of this variant is shown in Figure 12.16.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint