Patty
There is not a simple way using the chart wizard.
However it can be done. Firstly next to your column set up a column that
will act as your 'bins' (this will be clearer later). If you want to count
how many number 1s, 2s, 3s etc. then just make a column starting with 1, then
2, 3 etc. all the way down to the numbers you want to count (42 in your
case?). NB - if you use 2,4,6 instead if 1,2,3 then this will count the
number of 1s and 2s, 3s and 4s etc.
Select <Tools> and if you can see <Data Analysis...> then select that
option. If <Data Analysis...> is not an option then select
<Tools><Add-Ins...> and check mark <Analysis Toolpak>. this will make <Data
Analysis> visisble under the <Tools> menu.
Select <Data Analysis> and select <Histogram>. Here select your 'Input
Range' first i.e. your column of numbers, and then highlight your 'bins'
range that you set up earlier.
Check the <Chart Output> box and then whether you want the chart to appear
in the current worksheet (Output Rnage) or a new worksheet (New Worksheet
Ply). Then press <OK>. This will produce a small table summarising your data
and a chart to match.
Hope this helps.
Alex
