Minimize this window
Open Excel
Then click this application on the task bar to restore this page.

Look on your task bar. You should see "Microsoft Excel - Book 1" as one of the choices. Multitasking will require you to switch back and forth between files.

You could try resizing the windows so that you can view both applications at the same time. Or you can read this one then click "Microsoft Excel" on the task bar to complete your assignments.

Today we will be using Microsoft Excel to create a Histogram. It is very important that you complete this activity as I will show you a way to do this that makes sense (Excel instructions don't!)

We will create a Histogram of the data shown on the right.
The data is too varied to make a bar graph so we will need to group the data into intervals.

Step 1 is to determine the range of the data. What is the range of the data shown in the table?

Now we need to decide on an appropriate interval.
If we round 76 to 80 then our intervals can be 20 minutes and we will have 4 bars on our graph.

Go to Excel and type the intervals into A1:A4 as shown on the right.

Now tally each piece of data and record the frequency in the table.

We need to make sure that the total of our frequencies matches the total of the data set. There are 22 pieces of data so the sum of column B should be 22.
In cell B5 type or paste: =SUM(B1:B4)
then press [enter] to tell Excel to calculate.
What is the value shown in cell B5?

Ok we are ready to make our histogram!
Highlight all of your data (and only the data) that you want to graph.
Highlight cells A1:B4 as shown in the picture on the right.

Click Insert from the menu bar.
Select Chart

I have never seen a 3D Histogram so let's stick with the default option (clustered column) as shown on the picture on the right.
Remember - Excel calls normal bar graphs Column Graphs!
Select Next on the Chart Wizard to continue to step 2.

You should be looking at a boring and flat bar graph. We do not want to make any changes so click next to move to step 3.

We need to add a title and get rid of the legend!
Let's type (or paste) the title: Homework Time Last Night into the Chart Title text box.
Type or paste Minutes into the Category X axis text box.
Type or paste Students into the Category Y axis text box.

Now get rid of the legend by clicking the legend tab.
Click the check box for show legend to make the check go away.

Choose Next to move to the location step.
Choose the radio button for As new sheet
Name the new sheet: Histogram
Choose finish to start working on the graph!

Let's make it look like a histogram - Are you ready to follow directions and learn a secret method that very few people know?

Right Click any of the bars
Click format data series

Choose the Options tab
Change the gap width to 0
Press Ok to view your Histogram!

Before I leave you alone to let you decorate this Histogram like any other graph, we need to take care of a few don't forgets!

Put your name on your graph.
Click view from the menu bar
Click Header and Footer

Click Custom Header and put your name in the Right Section
Click OK
Choose Custom Footer
Put your curser into the center section
Click the index card as shown in the picture above.
The center section will print the sheet title and shows this as "&[Tab]"
Select OK to exit the footer wizard.
Select OK to exit the Header and Footer Wizard.
You should now be looking at your Histogram.

A final note before decorating. Histograms should use vibrant colors that contrast with each other. This helps to separate the bars since there are no gaps!