On Thu, 25 May 2006, in microsoft.public.excel.charting,
Tom said:

I'm trying to create a very basic chart type: a histogram. I'm amazed that
there is no "histogram" type of chart already in Excel, but I can find
neither it nor any type that I could adapt to that application.

It is amazing, isn't it? It's part of how Excel is just generally weak
on statistics graphing. There's no built-in box-and-whisker plot either
(don't get me started on how badly Pivot tables support medians,
quartiles, etc.) There are some tools in the Data Analysis Pak add-in,
but they're not worth much.

Use the COUNTIF() function to make a table based on the data set, then
plot that range.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.