1 Creating Charts

Using the data in cells A2 through E6, create a 2D Clustered Column Chart.

1. Select cells A2 through E6
2. Click the Insert tab
3. In the Charts group, click the Insert Column or Bar Chart drop-down arrow
4. Under 2-D Column, click the Clustered Column option

2 Moving Charts

Move the pie chart to its own worksheet. Accept the default worksheet name.

1. Select the Pie Chart
2. Click the Design tab under Chart Tools
3. In the Location group, click Move Chart
4. Click the New Sheet option
5. Click the OK button

3 Add Data Series To Charts

Add the Beginners data series to the pie chart on the Chart1 worksheet. While doing so, add the value in cell A8 as a series name to the chart.

1. Click the Chart1 worksheet
2. Click the Design tab under Chart Tools
3. In the Data group, click Select Data
4. In the Horizontal (Category) Axis Labels area, click the Edit button
5. Select cells B2 through F2
6. Click the OK button
7. In the Legend Entries (Series) area, click the Edit button
8. Click the arrow to the right of Series Values
9. Select cells B8 through F8
10. Press the Enter key
11. Click in the Series Name field
12. Click cell A8
13. Click the OK button twice

4 Switch Source Data

On the column chart, switch the source data so that the columns on the chart are showing numbers for locations by time of day instead of time of day by location.

1. Click the Column chart on the worksheet
2. Click the Chart Design tab
3. In the Data group, click Switch Row/Column

5 Chart Elements

On the column chart on Sheet1, delete the horizontal axis title and set a vertical axis title with the name, Students. Then, change the chart title to the name, Swimming Attendance.

1. Click the Column chart on the Sheet1 worksheet
2. Click the green plus sign
3. Click Axis Titles
4. While hovering over Axis Titles, click the arrow that appears to the right.
5. Clear the Primary Horizontal check box
6. In the chart, select the text, Axis Title
7. Type: Students
8. In the chart, select the text, Chart Title
9. Type: Swimming Attendance
10. Click anywhere on the chart