Make a "bin" - list of numbers that catch all your days-to-sell values.
Let's say in F1:F10 you have 1,2,3...10
Let's say your data base is in A1:B100 (item, days)
Select G1:G10
Type =FREQUENCY(F1:F10,B1:B100) and commit this with ctrl+shift + enter (Not
just enter)
Make a Line chart of F1:G10
OR learn about Pivot Tables
ttp://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"PAL" wrote in message
...
I have about 100 rows of data, 2 columns. Column A has names of products,
Column B has the number of days it took to sell them. I would like to
look
at the distribution:
Y axis, frequency of days
X axis, the number of days
I guess that is a bell curve. Ideas?
Thanks.