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:
- Open a new Spreadsheet in Microsoft Excel
- 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.
- 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).
- Click on the Chart Wizard.
- Select Column.
- Keep going through the steps.
- The title of the Graph should be: Deadly Volcanoes
- The Label along the X axis should be: Volcano
- The Label along the Y axis should be: Number of Deaths
- 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:
- Create a table in Excel
- Enter your data
- Create a bar chart and label it properly
- Drop your assignment into the Quesar folder on Sablab
Sabin School