Portland Public Schools
Portland, Oregon

Sabin image logoSabin School

Achieve anything
through education

4013 NE 18th Ave. | Portland, OR 97212
Phone: (503) 916-6181 | Fax: (503) 916-2669

Deadly Volcanoes

We've used a pie chart to look at data and now we're ready to create a bar graph. We'll be using Microsoft Excel and the data from the table shown below that lists the deadliest volcanoes known to humans. Here's what you need to do:

  1. Open a new Spreadsheet in Microsoft Excel
  2. Type the table as you see it below, except make sure that you type the name of the volcano in column A and the number of deaths in column B.
  3. To make the bar graph(chart), you'll highlight only the number of deaths and the name of the volcano (not the row headings or the other columns. We'll be using this information later on another assignment).
  4. Click on the Chart Wizard.
  5. Select Column.
  6. Keep going through the steps.
  7. The title of the Graph should be: Deadly Volcanoes
  8. The Label along the X axis should be: Volcano
  9. The Label along the Y axis should be: Number of Deaths
  10. Save your graph in the Supernova folder in Sablab
Deaths Volcano Country When Major Cause of Death
92,000 Tambora Indonesia 1815 Starvation
36,417 Krakatau Indonesia 1883 Tsunami
29,025 Mt. Pelee
Martinique 1902 Ash flows
25,000 Ruiz Colombia 1985 Mudflows
14,300 Unzen Japan 1792 Volcano collapse, tsunami
9,350 Laki Iceland 1783 Starvation
5,110 Kelut Indonesia 1919 Mudflows
4,011 Galunggung Indonesia 1882 Mudflows
3,500 Vesuvius Italy 1631 Mudflows, lava flows

At the end of this assignment, you should be able to:

  1. Create a table in Excel
  2. Enter your data
  3. Create a bar chart and label it properly
  4. Drop your assignment into the Quesar folder on Sablab