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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 08: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 02:53 PM |
TOC using paragraph numbers instead of Page numbers | cmac | Page Layout | 8 | May 16th, 2004 01:32 PM |