Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions | |||
finding common numbers in large lists | Excel Worksheet Functions |