How to Histogram w/o raw data but histogram Table on Excel

Hi

If I have raw data, then I understand the method of doing Histogram
with Excel.

What is if the Histogram is already presented in a Table and I have to
plot the diagram in Excel?

eg. (Note "->" means less then the upper value)

Range Freq
0->10 2
10->20 12
20->30 15
30->40 10
40->50 1

Can Excel take the above data and plot an Histogram?

Is there anything other than Excel?

2005 -

> Can Excel take the above data and plot an Histogram? <

Yes. Use the Chart Wizard to create a Column chart type.

Select the chart, and choose Chart | Source Data | Series.

Your "Freq" data are chart Values, and your "ranges" are chart Category (X)
axis labels.

> Is there anything other than Excel? <

In my life, yes.

- Mike
www.mikemiddleton.com

"2005" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> If I have raw data, then I understand the method of doing Histogram
> with Excel.
>
> What is if the Histogram is already presented in a Table and I have to
> plot the diagram in Excel?
>
> eg. (Note "->" means less then the upper value)
>
> Range Freq
> 0->10 2
> 10->20 12
> 20->30 15
> 30->40 10
> 40->50 1
>
> Can Excel take the above data and plot an Histogram?
>
> Is there anything other than Excel?
>