Chart of frequences of values
 

Hello,


How can I create chart of value´s frequences according to a frequence
table? (see attachement)

Thanks a lot.


+-------------------------------------------------------------------+
|Filename: graph.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3691 |
+-------------------------------------------------------------------+

--
balcovja
------------------------------------------------------------------------
balcovja's Profile: http://www.excelforum.com/member.php...o&userid=26239
View this thread: http://www.excelforum.com/showthread...hreadid=395775

Give us a brief description of the data - cannot open attachment.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"balcovja" wrote in
message ...

Hello,


How can I create chart of value´s frequences according to a frequence
table? (see attachement)

Thanks a lot.


+-------------------------------------------------------------------+
|Filename: graph.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3691 |
+-------------------------------------------------------------------+

--
balcovja
------------------------------------------------------------------------
balcovja's Profile:
http://www.excelforum.com/member.php...o&userid=26239
View this thread: http://www.excelforum.com/showthread...hreadid=395775

balcovja wrote:
Hello,


How can I create chart of value´s frequences according to a frequence
table? (see attachement)

Thanks a lot.


+-------------------------------------------------------------------+
|Filename: graph.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3691 |
+-------------------------------------------------------------------+

--------------------

Go into Excel's help and ask about the function HISTOGRAM()

Bill

balcovja -

How can I create chart of value´s frequences according to a frequence
table? (see attachement) <

Your attachment is not available, and if it was I would not open it.

If you already have a frequency distribution (values or ranges-of-values in
a column on the left with associated frequency counts in a column on the
right), use Excel's Chart Wizard to create a Column chart type.

Instead, if you have raw data, use Excel's Histogram tool (see Help for
instructions), or use my free "Better Histogram" add-in available at
www.treeplan.com.

- Mike
www.mikemiddleton.com