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

On to the next chart type. To show the percentages that make up one total, a pie chart gets the job done effectively.

Suppose you want to focus on US commercial space revenues for 1994 — the last column of data in Table 3-1. You catch people’s attention when you present the data in the form of a pie chart, like the one in Figure 3-10.

FIGURE 3-10: A pie chart of the last column of data in Table 3-1.

Here’s how to create this chart:

1 Enter your data into a worksheet.It’s pretty easy. I’ve already done this.

2 Select the data that go into the chart.I want the names in column A and the data in column F. The trick is to select column A (cells A2 through A7) in the usual way and then press and hold the Ctrl key. While holding this key, drag the cursor from F2 through F7. Voilà — two non-adjoining columns are selected.

3 Choose Insert | Recommended Charts from the main menu and pick Pie Chart from the list on the left side of the screen.

4 Modify the chart.Figure 3-11 shows the initial pie chart (after I added the title) on its own sheet. To get it to look like Figure 3-10, I had to do a lot of modifying. First, I formatted the legend as in the preceding example.The numbers inside the slices are called data labels. To add them, I select the chart (not just one slice) and then click the Chart Elements button. I then check the box next to Data Labels.To change the font color of the labels, click one of the data labels and select Text Options in the Format Data Labels pane that appears. Click the Solid Fill radio button and change the color from black to white. Press Ctrl+B to make the font bold.

FIGURE 3-11: The initial pie chart, on its own sheet.

Whenever you set up a pie chart, always keep the following in mind… .