charting particular numbers
 

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.

charting particular numbers
 

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

"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.

charting particular numbers
 

This page describes several ways to turn a column of numbers into
histogram-ready data:

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Alex" wrote in message
...
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

"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.