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
ToolsAdd-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

"patty" wrote:

in a chart in excel, is there a way to take one column and find out how many
times numbers pop up. say numbers 1-42, I want to know how many times each
of the numbers show up.