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

If I had selected Excel’s seventh recommended chart, I would have created a set of columns that presents the same information in a slightly different way. This type of chart is called Stacked Columns. Each column represents the total of all the data series at a point on the x-axis. Each column is divided into segments and each segment’s size is proportional to how much it contributes to the total. Figure 3-8 shows this.

FIGURE 3-8: A stacked column chart of the data in Table 3-1.

I inserted each graph into the worksheet. Excel also allows you to move a graph to a separate sheet in the workbook. Click on the chart to make the Chart Design tab visible. Then choose Chart Design | Move Chart (it’s on the extreme right side of the Chart Design tab) to open the Move Chart dialog box. Click the New Sheet radio button to add a sheet and move the chart there. Figure 3-9 shows how the chart looks in its own chart sheet. As you can see in Figure 3-9, I relocated the legend from Figure 3-8.

FIGURE 3-9: The Stacked Column chart, in its own chart sheet.

This is a nice way of showing percentage changes over the course of time. If you just want to focus on percentages in one year, the next type of graph is more effective.