Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
Extend the skills you learned in this chapter and experiment with new skills. You may need to
use Help to complete the assignment.
Making Use of the Chart Tools on the Design Tab
Instructions: Complete the following tasks.
1. Start Excel. Open the workbook Extend 6-1 Tennis Summary from the Data Files for Students and
then save the workbook as Extend 6-1 Tennis Summary Complete. See the inside back cover of this
book for instructions for downloading the Data Files for Students or see your instructor for infor-
mation on accessing the ﬁ les required in this topic. Click the Chart tab. Click the chart to select it
and display the Design tab on the Ribbon.
2. Click the Change Chart Type button on the Design tab on the Ribbon and then choose a Line
chart to change the 3-D Bar chart to a Line chart. One at a time, repeat this step for each of the
following chart types: Bar chart, Area chart, Surface chart, and Doughnut chart. Finally, choose the
Column chart type 3-D Cone (column 1, row 3).
3. Click the More arrow (lower arrow) in the Chart Layouts group on the Design tab on the Ribbon
to display the Chart Layouts gallery. Choose Layout 2 (column 2, row 1) in the Chart Layouts gal-
lery. Repeat this step for the following layouts: Layout 8 and Layout 9. Finally, choose Layout 5
(column 2, row 2).
4. Click the More arrow (lower arrow) in the Chart Styles group on the Design tab on the Ribbon
to display the Chart Styles gallery. One at a time, choose three different Chart Styles. Finally,
choose Style 38 (column 6, row 5) as shown in Figure 6–91. Remove the axis title from the left side
of the chart.
5. Change the document properties as speciﬁ ed by your instructor. Change the Chart sheet header
with your name, course number, and other information requested by your instructor. Change the
print orientation to landscape. Print the Chart sheet using the Fit to option. Save the workbook.
6. Submit the assignment as speciﬁ ed by your instructor.