Microsoft Office Tutorials and References
In Depth Information
2. Select the range A5:F35, and then start the Chart Wizard.
3. Use the Chart Wizard to create a stock chart using the Volume-Open-High-Low-Close
subtype. Set “Mitchell Oil” as the chart title, “Date” as the Category axis title, “Shares
Traded” as the Value axis title, and “Stock Value” as the Second value axis title. Hide
the chart’s legend. Place the chart on a chart sheet named “Stock Chart”. Move the
Stock Chart sheet to the end of the workbook.
4. Change the scale of the first value axis to range from 0 to 2,000,000. Set the display
units to millions and display the units label on the chart. Change the scale of the sec-
ond value axis to range from 10 to 30. Display values on both value axes to show
two decimal places.
5. Change the alignment of the second value axis title to 90 degrees.
6. Double-click the column data series that displays the volume of shares traded and,
using the Options tab, reduce the gap between adjacent columns to 0 pixels.
7. Change the fill color of the columns to blue. Change the fill color of the plot area to
8. In a stock chart, the daily chart values will either show an increase or a decrease
from the previous day. Increases are shown with an up bar displayed in white and
decreases are showed in a down bar displayed in black. Select the up bars by right-
clicking one of the white bars and clicking Format Up Bars on the shortcut menu.
Change the fill color of the up bar from white to green. Select the down bars by right-
clicking one of the black bars and clicking Format Down Bars on the shortcut menu.
Change the fill color of the down bar from black to red.
9. In the upper-left corner of the plot, use the Drawing toolbar to insert the Explosion 2
AutoShape. Insert the following text into the shape: “36% increase in 6 weeks!”.
Increase the Explosion 2 AutoShape sufficiently to display the entire text. Change the
fill color to yellow and the font color to red.
10. Add the Shadow Style 10 drop shadow to the AutoShape.
11. Format the printed output for the chart sheet so that your name, the date, and the file-
name are displayed in the printout’s right footer, each on a separate line.
12. Print the Stock Chart chart sheet.
13. Save and close the workbook.
Case Problem 4
There are no Data Files needed for this Case Problem.
Relating Cancer Rates to Temperature A 1965 study analyzed the relationship between
the mean annual temperature in 16 regions in Great Britain and the annual mortality rates
in those regions for a certain type of breast cancer. Lynn Watson is working on a sympo-
sium on the history of breast cancer research and has asked you to chart the data from this
historic study. Figure 4-38 shows a preview of the workbook and chart that you’ll create.
Test your knowledge of
charts by creating a
workbook with an XY
(scatter) chart that pre-
sents data from a can-
cer research study.