Microsoft Office Tutorials and References
In Depth Information
10. Change the ﬁ ll color of the Visitor Center series to orange.
11. In the Park Usage Data worksheet, select the range B3:D3;B16:D16, and then insert
a 3-D pie chart.
12. Move the embedded chart to the Monthly Visits chart sheet.
13. Insert the chart title Total Visits above the pie chart, and set its font size to 16 points
and its color to white.
14. Change the color of the Visitor Center slice to orange.
15. Remove the chart legend from the pie chart.
16. Add data labels to the inside of each slice, displaying the slice’s value.
17. Change the ﬁ ll color of the chart area to none (removing the ﬁ ll color) and change
the border color to no line (removing the border). Resize the embedded pie chart
and move it to the lower-left of the column chart.
18. Go to the Park Usage Data worksheet, and then add data bars to the range B4:D15.
Modify the rule for the data bars so that the maximum data bar length matches a
value of 100,000.
19. Save and close your workbook, and then submit the ﬁ nished workbook to your
instructor, either in printed or electronic form, as requested.
Case Problem 2
Data Files needed for this Case Problem: Tornado.xlsx, Cloud.jpg
Midwest Tornado Institute Joyce Bishop is a meteorologist at the Midwest Tornado
Institute located in Decatur, Illinois. Joyce is preparing for a talk she is giving to a local
civic group on the possible effects of global warming on tornados. She has collected data
on minor, moderate, and major tornado sightings in ﬁ ve-year periods during the second
half of the twentieth century and wants you to create a graph for her talk showing her
data. She’s already entered this data into an Excel workbook. Complete the following:
1. Open the Tornado workbook located in the Excel4\Case2 folder included with your
Data Files, and then save the workbook as Tornado Sightings . In the Documentation
sheet, enter your name in cell B3 and the date in cell B4.
2. In the Sightings History worksheet, select the range A3:E13, and then insert a 2-D
clustered column chart. Move the embedded chart to a chart sheet named Sightings Chart .
3. Change the chart style to Style 32 (the last chart style in the fourth row of the Chart
4. Insert the chart title Tornado Sightings: 1950–1999 at the top of the chart, and then
change the font size to 24 points.
5. Add the vertical axis title Sightings in a 14-point font with horizontal orientation.
Add the horizontal axis title Years in a 14-point font.
6. Move the legend to the bottom of the chart, and then set its font size to 14 points.
7. Change the line style of the horizontal gridline from a solid line to a dashed line.
Hint : Use the Dash type button in the Line Style options in the Format Major (
Gridlines dialog box.)
8. Add vertical gridlines to the major tick marks in the chart. Display the gridlines as
9. Change the chart type of the All data series from a column chart to a 2-D line chart.
Change the color of the line to standard blue.
10. Select the plot area and change the ﬁ ll to a picture ﬁ ll, using the Cloud.jpg ﬁ le
located in the Excel4\Case2 folder included with your Data Files. ( Hint : Open the
Format Plot Area dialog box. In the Fill options, click the Picture or texture ﬁ ll option
button, click the File button, and then locate and select the picture ﬁ le.)