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

  • Thread starter Thread starter 2005
  • Start date Start date
2

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?
 
2005 -
Can Excel take the above data and plot an Histogram? <
Click to expand...

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? <
Click to expand...

In my life, yes.

- Mike
www.mikemiddleton.com
 
Back
Top