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?

How to Histogram w/o raw data but histogram Table on 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" wrote in message
oups.com...
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?