Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
In the Lab continued
3. Select the legend on the right side of the chart and delete it. Add the chart title by clicking the
Layout tab on the Ribbon, then clicking the Chart Title button. Click Above Chart in the Chart
Title gallery. Format the chart title as shown in Figure 3–86.
4. To change the color of the cylinders, click one of the cylinders and use the Shape Fill button on
the Format tab on the Ribbon. To change the color of the wall, click the wall behind the cylinders
and use the Shape Fill button on the Format tab on the Ribbon. Use the same procedure to change
the color of the base of the wall.
5. Rename the sheet tabs Eight-Year Financial Projection and 3-D Cylinder Chart. Rearrange the
sheets so that the worksheet is leftmost, and color their tabs as shown in Figure 3–86.
6. Click the Eight-Year Financial Projection tab to display the worksheet. Save the workbook using
the same ﬁ le name (Lab 3-1 Salioto Auto Parts Eight-Year Financial Projection) as deﬁ ned in
Part 1. Submit the workbook as requested by your instructor.