Microsoft Office Tutorials and References
In Depth Information
this data in a 3-D chart, breaking down the results by sites and month. She would also like
a chart that shows the monthly totals with each column organized by visitor center.
To complete this task:
1. Open the Park1 workbook located in the Tutorial.04\Cases folder included with
your Data Files, and then save the workbook as Park2 in the same folder. Enter your
name and the current date in the Documentation sheet and then switch to the Park
2. Select the range A3:D15, and then start the Chart Wizard.
3. Use the Chart Wizard to create a 3-D column chart that compares values across cate-
gories and across series. The chart title should be “2006 Usage Statistics”. The X axis
title should be “Month”. The Series axis title should be “Sites”, and the Value axis title
should be “Visitors”. Place the chart legend at the bottom of the chart. The chart
should be placed on a new chart sheet named “Usage Chart”.
4. Within the Usage Chart chart sheet, change the elevation of the 3-D view to 24 degrees,
the rotation to 198 degrees, and the perspective to 20 degrees. Change the color of the
Exit Glacier series to blue, the Visitor Center series to red, and the Others series to
green. Change the color of the walls and floor of the 3-D chart to white. Change the
color of the chart area to tan. Display the chart title in a blue 18-point font.
5. Return to the Park Usage worksheet.
6. Select the range A3:D15 again (if necessary), and then start the Chart Wizard again.
7. Use the Chart Wizard to create a Stacked Column chart that compares the contribu-
tion of each value to a total across categories. The chart title should be “2006 Usage
Statistics”. The X axis title should be “Month” and the Value axis title should be
“Visitors”. The legend should be displayed at the bottom of the chart. Place the result-
ing chart on a chart sheet named “Usage Chart 2”.
8. Change the color of the Exit Glacier series to blue, the Visitor Center series to red,
and the Others series to green. Change the color of the plot area to white and the
chart area to tan. Display the chart title in an 18-point blue font.
9. Move the Usage Chart and Usage Chart 2 chart sheets to the end of the workbook.
10. Format the printed output for the two chart sheets so that your name, the date, and
the filename are placed on separate lines in the page’s right footer.
11. Print the contents of the Usage Chart and Usage Chart 2 chart sheets.
12. Save and close the workbook.
Case Problem 2
Data File needed for this Case Problem: Powder1.xls
Dantalia Baby Powder Kemp Wilson is a quality control engineer for Dantalia Baby Powder.
Part of the company’s manufacturing process involves a machine called a “filler,” which pours
a specified amount of powder into bottles. Sometimes the heads on the filler become partially
clogged, causing the bottles to be under-filled. If that happens, the bottles must be rejected. On
each assembly line, there are a certain number of bottles rejected during each shift.
Broaden your knowl-
edge and challenge
your skills by exploring
how to use Excel to cre-
ate a Pareto quality con-
Kemp’s job is to monitor the number of defective bottles and locate the fillers that may have
clogged filler heads. One of the tools he uses to do this is a Pareto chart. A Pareto chart is a
column chart in which each column represents the total number of defects assigned to differ-
ent parts of the production process. In this case, the columns would represent the 24 different
fillers in the assembly line. The columns are sorted so that the part that caused the most
defects is displayed first, the second-most is displayed second, and so forth. Superimposed on
the columns is a line that displays the cumulative percentage of defects for all of the parts.