View Single Post
  #3  
Old February 19th, 2006, 08:23 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
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.