Spreadsheets III Exercise: Graphs and Charts

What to do How to do it
Save a copy of the exercise file excel3.xls to your floppy disk.
  1. Right-click the link excel3.xls and click "Save Target As ..."
  2. Select 3 1/2 Floppy (A:) from the "Save In:" pull-down menu
  3. Double-click your folder
  4. Double-click the Spreadsheets folder
  5. Click the Save button
Open your copy of the file.
  1. Choose a file to be opened using one of the following methods:
    Open Microsoft Excel and either click File, Open, click the Open button, or Press Ctrl-O
    Open Windows Explorer or My Computer
  2. Double-click 3 1/2 Floppy (A:) or select it from the Look In: menu
  3. Double-click your folder
  4. Double-click the Spreadsheets folder
  5. Double-click excel3.xls
Type Charting Practice in the upper left cell. Click the Overview tab. Click in cell A1, type Charting Practice and press Enter.
Put your name in cell A2. Type your first and last name and press Enter.
Put today's date in cell A3. Type in the date and press Enter.
Save your changes often. Press Ctrl-S.
Create a pie chart for the Energy data.
  1. Click the Energy tab. Select cells A3:B7.
  2. Select Chart from the Insert menu or click the Chart Wizard button on the standard toolbar.
  3. In the Chart type list, select Pie. Click Next. Click Next again.
  4. Click the Titles tab. For the chart title, type World Commercial Energy Consumption.
  5. Click the Legend tab. Remove the tick in the "Show legend" box.
  6. Click the Data Labels tab. Click "Show label and percent". Click Next. Click Finish.
  7. Move and resize the chart so it fills the area from about A9 to about C30.
  8. Click on the graph. Click File, Print Preview, Close.
  9. Click in any cell. Click File, Print Preview, Close. Press Ctrl-S.
Create an XY (Scatter) chart for the Income data.
  1. Click the Income tab. Select cells A3:B26. Click the Chart Wizard button.
  2. For the Chart type select XY (Scatter). Click "Press and Hold to View Sample."
  3. For the Chart sub-type select "Scatter with data points connected by smoothed lines." Click Next. Click Next again.
  4. Click the Titles tab. For the chart title, type US National Income, US$ Billion.
  5. Click the Legend tab. Remove the tick in the "Show legend" box. Click Next. Click Finish.
  6. Move and resize the chart so it fills C3 to J26. Print preview if desired. Press Ctrl-S.
Create a bar chart for the Waste data.

Put the chart on a sheet named Waste Chart.
  1. Click the Waste tab. Click cell A3. Click the A->Z button.
  2. Click cell E4. Type =c4/d4*1000 and press Enter (to calculate the population). 
  3. Click cell E4. Drag the fill handle down to E20. Decrease to one decimal.
  4. Select cells B3:D20. Click the Chart Wizard button. Click Next.
  5. Click the Series tab. Click the Remove button. Click Next.
  6. Click the Titles tab. For the chart title, type Annual Household Waste.
  7. For the Category (X) axis, type Country. 
  8. For the Value (Y) axis, type Waste per Person (kilograms).
  9. Click the Legend tab. Remove the tick in the "Show legend" box. Click Next. 
  10. Select "As new sheet". Type Waste Chart. Press Enter or click Finish. Press Ctrl-S.
Create a column chart for the Birth-Death data.

Put the chart on a sheet named Birth-Death Chart.
  1. Click the Birth-Death tab. 
  2. Click cell D4. Type =(B4-C4)*10% and press Enter. Fill the formula down to D10.
  3. Select cells A3:C10. Click the Chart Wizard button.
  4. For the Chart sub-type, select "Clustered column with a 3-D visual effect." Click Next. 
  5. Click Rows. Click Columns. Decide which of the two you prefer. Click Next.
  6. Click the Titles tab. 
  7. For the Chart title, type World Birth and Death Rates per 1000 Population, 1985-1990.
  8. For the Category (X) axis, type Continent. 
  9. For the Value (Z) axis, type Number per Thousand. Click Next.
  10. Select "As new sheet". Type Birth-Death Chart. Press Enter or click Finish.
  11. Right-click Africa and click Format Axis. Click the Alignment tab. Change Degrees to 45. Click OK. Press Ctrl-S.
Create a stacked column chart for the Enrollment data.

Put the chart on a sheet named Enrollment Chart.
  1. Click the Enrollment tab. Fill in the Total column to find total enrollment each year.
  2. Select cells B3:D14. Click the Chart Wizard button.
  3. For the Chart sub-type, select "Stacked Column." Click Next.
  4. Click the Series tab. Click in the Category (X) axis labels box. Type or select A4:A14. Click Next.
  5. Click the Titles tab. For the chart title, type US Enrollment in Education, Millions. Click Next.
  6. Select "As new sheet". Type Enrollment Chart. Press Enter or click Finish. Press Ctrl-S.
Create a 3-D column chart for the Forex data using percentage differences from the average.

Put the chart on a sheet named Forex Chart.
  1. Click the Forex tab. 
  2. Click cell C14. Click the fx button. Select the average function. Click OK. Click OK.
  3. Drag the fill handle from C14 to F14 (to copy the average for all currencies).
  4. Click in cell G4. Type =(C4-C$14)/C$14. (C is relative, 14 is absolute.) Press Enter.
  5. Drag the fill handle down from G4 to G13. Drag the fill handle across to J13.
  6. Select cells A3:J13. For the Chart sub-type, select "3D Column". Click Next.
  7. Click the Series tab. Click the Remove button four times. Click Next.
  8. Click the Title tab. For the Chart title, type Forex Rates, Kampala, Uganda, March 6, 2003.
  9. For the Category (X) axis title, type Forex Bureau.
  10. For the Series (Y) axis, type Currency.
  11. For the Value (Z) axis, type Percent Difference from Average.
  12. Click the Legend tab. Remove the tick in the "Show legend" box. Click Next.
  13. Select "As new sheet". Type Forex Chart. Press Enter or click Finish. Press Ctrl-S.
  14. To make a profit, which currency should you buy from whom and sell to whom?  
Save your changes to the document and exit.
  1. Press Ctrl-S to save the document.
  2. Click File, Exit to close Excel.