How Do I Create a Histogram Using Continuous Data in Excel 2007?

1. Open the Microsoft Excel 2007 application on your computer. Enter the continuous data into the spreadsheet.
2. Make sure to create one column with an input range of continuous data and another column with a bin range of data, which must be entered in ascending order.
3. Click on the “Data” tab and then click on the “Data Analysis” option from the “Analysis” group. The Analysis Tools dialog box will then appear.
4. Click on the “Histogram” option and then click on the “OK” option. Click on the “Collapse Dialog” button in the “Input Range” section and select the input range of data that you want represented in your histogram.
5. Click on the “Collapse Dialog” button again to return to the Analysis Tools dialog box. Click on the “Collapse Dialog” button next to the “Bin Range” section and select the bin range data in the spreadsheet.
6. Click on the “Collapse Dialog” button. Click on the box next to the “Labels” field if you want labels included with the histogram.
7. Make any changes to the setting in the “Output options” section to meet your preferences. Click on the box next to the “Cumulative Percentage” field so that it’s deselected.
8. Click on the “OK” button to save the changes. The histogram with the continuous data will then appear on the spreadsheet.