software

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 quot;-gt;quot; means less then the upper value)

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

Can Excel take the above data and plot an Histogram?

Is there anything other than Excel?2005 -

gt; Can Excel take the above data and plot an Histogram? lt;

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

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

Your quot;Freqquot; data are chart Values, and your quot;rangesquot; are chart Category (X)
axis labels.

gt; Is there anything other than Excel? lt;

In my life, yes.

- Mike
www.mikemiddleton.com

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