Читать книгу Statistical Analysis with Excel For Dummies - Joseph Schmuller - Страница 51

In addition to the application in the preceding section, you use the scatter chart to create something like a line chart. The conventional line chart works when the values on the x-axis are equally spaced, as is the case for the data in Table 3-1.

Suppose that your data look like the values in Figure 3-30. Veterans of earlier Excel versions (Excel 2010 and before) might remember having to figure out that a scatter chart with lines and markers was the best way to visualize these data.

Excel now figures this out for you. Selecting the data and choosing Insert | Recommended Charts presents the Scatter with Straight Lines and Markers as the first option — although Excel labels it simply as Scatter. (See Figure 3-31.) This puts you on the road to the appropriate chart.

FIGURE 3-30: These data suggest a line chart, but the x-values aren’t equally spaced.

FIGURE 3-31: Recommended Charts suggests the appropriate chart for the data.

In Chapters 8, 10, 11, and 19, I show you still another use for the scatter chart. In those chapters, I apply Scatter with Smooth Lines. Stay tuned.