Use Tools | Data Analysis | Histogram
If you do not see Data Analysis then you need to but the Office/Excel CD in
the drive and use Add/Delete Programs to install this feature.
OR
You could use the FREQUENCY function to make a data table then make a column
chart. You can format the data series in a column chart so that the columns
have no gaps between them
Mike Middleton's page (which Bernard cited) is nice because it fixes the
category axis in a way that is not native to Excel, with labels between the
columns.
- Jon
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.