Full Column
Posted in Garden Antiques on 02/22/2009 01:36 pm by adminExcel graphs - Plotting/sorting data from a column full of data?
Software: Excel 2007
I have one thousand cells in a column containing numerical data, i would like to plot this data into a graph, many of the values are different, but some do occur more than once.
I know how to create a graph if i have the number of occurrences of something, but in this case i don't and so i need your help (maybe i'll need to write a VBA program to find out for me?)
I want to of course set ranges for the data (eg. 1-10, 11-20 etc.) in order to group it up, and later i will most definitely want to change what these ranges are depending on the results i get in the graph.
How do i go about doing this - the main problem i face is sorting the data and counting the occurrences of each - both individually and using ranges (1-10, 11-20 ... 91-100)
(Is there a way to do it without creating new cells of data and just use the graph function to calculate the number of occurrences for me and plot a graph based on ranges of that data?)
Thank you for your time
There is a function called FREQUENCY that allows you to define the "bin" size (ranges of values) and it will count the occurrences for you. You will have to create new cells of data but the frequency function makes it somewhat easy to do.
FREQUENCY function
http://office.microsoft.com/en-us/excel/HP052090971033.aspx
http://www.meadinkent.co.uk/xlfreq.htm
There is also a "Histogram tool" that is sort of a wizard for the FREQUENCY function. It's part of the Analysis Toolpak Add-in
Histogram Tool
http://office.microsoft.com/en-us/excel/HP010983641033.aspx
Load the Analysis Toolpak for Excel 2007
http://office.microsoft.com/en-us/excel/HP100215691033.aspx
Do a web search for...
Excel Frequency function tutorial
or
Excel Histogram tool tutorial
...and you will find several good sites that give step-by-step instructions.
| No items matching your keywords were found. |