create charts from that data that he can use in an article that reviews the history of oil production and consumption, and their impact on the size of the proven world oil reserves.
1. Open the Petro Chart, and then save the workbook as Petro Chart Reports.
2. In the Documentation sheet, enter your name in cell B3 and the date in cell B4.
3. In the World Oil Production worksheet, create a line chart of world oil production from 1980 to 2010 using the data from the range A6:G37. Move the chart to the Summary worksheet covering the range B4:H19.
4. Format the chart with the Style 9 chart style, and then change the chart title to Oil Production Historic Trends.
5. Change the line color for the North America data series to white, which is easier to read against the black backdrop. (Select the data series (the line), right-click it, Format data series, click Fill & Line icon, color,)
6. Revise the vertical axis scale so that the display unit is expressed in terms of thousands (most oil production reports are quoted in terms of thousands of barrels per day). (Double-click the vertical axis values, Change the �Display unit� to Thousands)
7. Double-click the vertical axis title �Thousands�, and enter Thousands of Barrels per Day.
8. In the World Oil Production worksheet, create a pie chart that displays the relative size of the oil production values for different regions in 2010 based on the data in the nonadjacent range B6:G6; B37:G37. Move the chart to a new chart sheet. Name the new chart sheet Oil Production Chart.
9. Make the following changes to the pie chart:
a. Format the chart with the Style 5 chart style.
b. Change the chart title to 2010 Oil Production and reduce its font size to 14 points.
c. Move the chart legend to the left edge of the chart area.
d. Add data labels outside of the pie slices showing the percentage associated with each region. (Chart Elements button (the plus sign (+) at top left of chart when it is selected), Data labels arrow, more options, check percentage, uncheck value, under Label position, select outside end.)
e. Change the color of the pie slice for the North America region to white.
10. In the World Oil Consumption worksheet, create a line chart that shows how oil consumption changed from 1980 to 2010 based on the data in the range A6:G37. Move the chart to the Summary worksheet covering the range B21:H36.
11. Change the chart title to Oil Consumption Historic Trends.
12. Copy the Oil Production Historic Trends line chart. Use Paste Special to paste the format of that chart into the Oil Consumption Historic Trends line chart.
13. In the Oil Production Chart worksheet, change the chart area background to a picture fill, using theCloud.jpg file. (Select chart, select chart area, Chart Tools Format tab, Shape Styles group, Shape Fill, Picture,)
14. Go to the World Oil Production worksheet, and then insert orange data bars in the range B7:G37. Insert blue data bars in the range H7:H37. (Conditional Formatting,) Note that the meaning of the lengths of the two sets of data bars is different because they are applied to different ranges.
15. In the Proven Reserves worksheet, in cell B37, insert a Sparkline, line, for the data in the range B6:B36. (Insert tab, Sparkline group,) Repeat to insert a Sparkline in cells C37 and D37.
16. Save the workbook, close it, and submit saved files to the instructor�s gradebook via Blackboard.
Comparison of Reserves to Production and Consumption
Year Oil Production
(Thousand of Barrels per Day) Oil Consumption
(Thousand of Barrels per Day) Proven Reserves
(Billions of Barrels)
1980 63,980 63,110 641.9
1981 60,610 60,960 648.8
1982 58,100 59,560 665.8
1983 57,930 58,790 665.5
1984 59,560 59,820 667.2
1985 59,160 60,080 697.8
1986 61,540 61,810 697.1
1987 62,100 63,090 698.3
1988 64,390 64,970 887.1
1989 65,510 66,070 905.7
1990 66,440 66,530 1,000.3
1991 66,340 67,210 997.2
1992 66,550 67,400 988.5
1993 67,100 67,570 995.3
1994 68,640 68,880 997.8
1995 70,310 70,100 641.9
1996 71,990 71,690 648.8
1997 74,220 73,460 665.8
1998 75,680 74,110 665.5
1999 74,820 75,870 667.2
2000 77,700 76,780 697.8
2001 77,650 77,510 697.1
2002 77,040 78,170 698.3
2003 79,460 79,720 887.1
2004 82,990 82,570 905.7
2005 84,420 84,080 1,000.3
2006 84,390 85,130 997.2
2007 84,260 85,810 988.5
2008 85,360 85,450 995.3
2009 84,330 84,700 997.8
2010 86,800 87,040 999.2
Source: U.S.Energy Information Administration
Place your order now to enjoy great discounts on this or a similar topic.
People choose us because we provide:
Essays written from scratch, 100% original,
Delivery within deadlines,
Competitive prices and excellent quality,
24/7 customer support,
Priority on their privacy,
Unlimited free revisions upon request, and
Plagiarism free work,