Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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 Cells and Inserting Multiple Charts
Instructions: Start Excel. Open the workbook Extend 1-1 Pack-n-Away Shipping. 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 ﬁ 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 24-point Arial, red, bold and subtitle of the worksheet to 16-point Arial Narrow, blue, bold.
2. Select the range A3:E8, click the Insert tab on the Ribbon and then click the More button in the
lowerright corner of the Charts group on the Ribbon to open the Insert Chart dialog box (Figure 1–100).
3. Insert a Stacked Line chart by clicking the Stacked Line chart in the gallery and then clicking the
OK button. Move the chart either below or to the right of the data in the worksheet. Click the
Design tab and apply a chart style to the chart.
4. With the same range selected, follow Step 3 above to insert a 3-D Area chart in the worksheet.
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 so that each chart does
not overlap the Stacked Line chart. Choose a different chart style for this chart than the one you
selected for the Stacked Line chart.