Domain 5 Lesson 1: Create & Modify Charts

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

Domain 5 Lesson 2: Format Charts

6.) Chart Layouts
​Change the chart type of the Swimming Attendance chart to a 3-D Clustered Column layout. Then, apply the Layout 5 layout to the chart.

1. Click the Swimming Attendance chart
2. Click the Design tab under Chart Tools
3. In the Type group, click Change Chart Type
4. Make sure that Column is selected on the left-hand side
5. Click the 3-D Clustered Column chart type from the list across the top of the All Charts tab
6. Click the OK button
7. In the Chart Layouts group, click the Quick Layout drop-down arrow
8. Click Layout 5

7.) Chart Styles
Apply the Style 9 style to the Swimming Attendance chart on Sheet1. Then, apply the Monochromatic Palette 3 color combination to the chart.

1. Click the Swimming Attendance chart on the Sheet1 worksheet
2. Click the Design tab under Chart Tools
3. In the Chart Styles group, click the Chart Styles drop-down arrow
4. Click Style 9
5. In the Chart Styles group, click the Change Colors drop-down button
6. Click the Monochromatic Palette 3 color group option

8.) Add Alternative Text
Add the text, Percentage of totals for each swim class, as alternative text to the Chart Area of the pie chart.

1. Select the entire pie chart
2. In the Chart Format tab, Current Selection group, ensure that the drop-down has Chart Area selected.
3. In the Chart Format tab, Accessibility group, click Alt Text
4. Click in the Alt Text field
5. Type: Percentage of totals for each swim class