A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

charting particular numbers



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2006, 10:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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.
Ads
  #2  
Old February 18th, 2006, 03:07 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
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.

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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set up mixed roman and standard page numbers? nicole General Discussion 2 November 30th, 2005 09:22 PM
formulas to numbers Steve New Users 2 September 16th, 2005 12:07 AM
Hightlighting Numbers & then all Cells to the right of these Numbers. Dave Worksheet Functions 4 August 29th, 2005 10:30 PM
Searcing multiple numbers Ken General Discussion 4 November 6th, 2004 03:53 PM
TOC using paragraph numbers instead of Page numbers cmac Page Layout 8 May 16th, 2004 01:32 PM


All times are GMT +1. The time now is 01:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.