How to Graph a Histogram Bin in Excel

1. Type the data you want on your histogram in column A. Use a separate cell for each piece of data.
2. Type your corresponding bin numbers into column B.
3. Click 'Data,' then 'Data Analysis.'
4. Click 'Histogram,' then 'OK.'
5. Click the 'Collapse Dialog' button next to 'Input Range,' and then highlight your data range, which is column A.
6. Click the 'Collapse Dialog' button next to 'Bin Range,' and then highlight your data range, which is column B.
7. Click 'OK.'