Using the Chart Wizard

Activity 1: Using the Chart Wizard

1.      Open the Grade Book workbook.

2.      Select the test data in the Grade Book worksheet, including the headings and student numbers, but not the main title or totals (cells B8 through F13).  

3.      On the Standard toolbar, click Chart Wizard.

4.      On the Standard Types tab, in Chart type, click Column.

5.      In Chart sub-type, click Clustered column with a 3-D visual effect.  

6.      Click Press and hold to view sample to see a sample of your data in the clustered column 3-D format.

7.      Click Next twice.

8.      In the Titles tab, in Chart title, type Test Grades.

9.      In the Category (X) axis, type Student Numbers.

10. In the Value (Z) axis, type Points. (The Z-axis title is available but the Y-axis is not, because it extends back into the chart.)

11. Click the Gridlines tab to select type of lines to show on your graph.

12. In Category (X) axis, clear the Major gridlines check box.

13. In Value (Z) axis, select Major gridlines.

14. To move the legend to the bottom, on the Legend tab, click Bottom.

15. Click Next for Chart Location.

16. Click As new sheet.

17. Click Finish to complete the chart process.

Attaching the graph as a new worksheet makes it easier to print a chart. You now have a readable and easy-to-understand chart. Attaching the chart as an object has the advantage of providing an immediate view of changes to the chart as you change the data.

Rotating the  Z-axis titles and enlarging chart titles

Activity 2: Rotating the  Z-axis titles and enlarging chart titles

1.      In the chart from the previous activity, click the chart title (Test Grades).

2.      On the Formatting toolbar, change the font size to 20 point.  

3.      Right-click the Z-axis title (Points).

4.      Click the Format Axis Title dialog box.

5.      On the Alignment tab, click the text line, and drag it up to the top of the semicircle to 90 degrees.  

6.      Click the Font tab and then change the font to bold and 14-point.

7.      Click OK.

8.      Right-click the X-axis title (Student Numbers).

9.      Click Format Axis Title.

10. Click the Font tab and then change the font to bold and 20-point.  

11. Click OK.

Adding colors to enhance data bars 

Activity 3: Adding colors to enhance data bars

1.      Right-click the first data bar.

2.      Click Format Data Series.  

3.      On the Patterns tab, click Dark Green in the first row.  

4.       Click OK.

5.      Right click on the 2nd data bar to select the data series (every lavender bar for each student)-then left click the first lavender data bar and change the color to Dark Blue.

Rotating the chart

Activity 4: Rotating the chart

1.      Right-click in the center of the chart.

2.      Click 3-D View.

3.      In the Elevation dialog box, type 15.

4.      In the Rotation dialog box, type 40.

5.      Click the Auto scaling and the Right angle axes boxes.

6.      Click Apply.

Click OK, and save your work

You have now completed this module. Take a few minutes to review and practice what you have learned..