urgent: Histogram and box plot with excel 2000 !

[This followup was posted to microsoft.public.excel.charting and a courtesy

newsgroup for further discussion.]

I'm sure that what you want to do is crystal clear to you. Unfortunately, the

same cannot be said about me. I have two questions about the posting.

1) A histogram, typically, is a column chart, i.e., a rectangular box that

touches the x-axis. A box plot, on the other hand, uses a rectangle that seems

to hang in mid air. So, I'm not sure of what exactly you want. Is it a

histogram that looks like a box plot? Or something else?

2) I'm not sure if there is any way for anyone to calculate statistical data

without a function or a formula. Whether one does it 'by hand' or by using a

built-in Excel function, or a (more robust) user-defined VBA function, some

function (or equivalent formula) has to be used. So, what exactly it is that

you want to do?

--

Regards,

Tushar Mehta

www.tushar-mehta.com

--

Quote:

> Hi !

> Does somebody know if there's anyway to build a box plot

> and histogram with excel 2000 ?

> I'm trying to build a histogram with statistic summarize

> such as - avarage, SD, median ect without using functions.

> Thanks in advanced

> Barak Mery