Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
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.
Formatting a Worksheet and Adding Additional Charts
Instructions: Start Excel. Open the workbook Extend 1– 1 Pack Right Moving Supplies. See the inside
back cover of this topic for instructions for downloading the Data Files for Students, or see your
instructor for information on accessing the i les required in this topic. Perform the following tasks
to format cells in the worksheet and to add two charts to the worksheet.
1. Use the commands in the Font group on the Home tab on the Ribbon to change the font of the
title in cell A1 to 22-point Arial Black, green, bold, and the subtitle of the worksheet to 14-point
Arial, red, bold.
2. Select the range A3:G8, click the Insert tab on the Ribbon, and then click the Dialog Box Launcher
in the Charts group on the Ribbon to open the Insert Chart dialog box. If necessary, drag the
lower-right corner of the Insert Chart dialog box to expand it (Figure 1– 77).
Clustered Horizontal
Cone chart type
Stacked Area in 3-D
chart type
Figure 1– 77
3. Insert a Stacked Area in 3-D chart by clicking the Stacked Area in 3-D chart in the gallery and then
clicking the OK button. You may need to use the scroll box on the right side of the Insert Chart
dialog box to view the Area charts in the gallery. Move the chart either below or to the right of the
data in the worksheet. Click the Design tab and apply a chart style of your choice to the chart.
4. Deselect the chart and reselect the range A3:G8, and then follow Step 3 above to insert a Clustered
Horizontal Cone chart in the worksheet. Move the chart either below or to the right of the data so
that each chart does not overlap the Stacked Area in 3-D chart. Make sure to make the values on
the horizontal axis readable by expanding the size of the chart. Choose a different chart style for
this chart than the one you selected for the Stacked Area in 3-D chart.
 
Search JabSto ::




Custom Search