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

[2005]

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?

 

[Mike Middleton]

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