Histograms in Excel

Posted by Javier Finkman on January 11, 2001 4:47 AM

I need to make an histogram (relative frequency graph) in Excel. The data analysis gives me an error when trying to graph the data. I do not know how to do it manually (a X-Y graph with bars??)

Posted by Mark W. on January 11, 2001 5:12 AM

Use a column chart. If cell A1:B7 contain:

{-3,0.00443184841193801
;-2,0.053990966513188
;-1,0.241970724519143
;0,0.398942280401433
;1,0.241970724519143
;2,0.053990966513188
;3,0.00443184841193801}

...the chart's series function would be:

=SERIES(,Sheet1!$A$1:$A$7,Sheet1!$B$1:$B$7,1)

Posted by Sanjay on January 11, 2001 5:43 AM