How do I get a histogram using EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Office 2007 how to you draw a histogram, given grouped data and
frequency?
I know you could do this with 2003 using the tools option.
Thanks
 
ngwenya -

If the data are already grouped, create a Column chart type.

The Histogram tool is used when you have ungrouped, raw data. It prepares a
frequency distribution, i.e., it groups the data, and then it creates a
Column chart.

If you have the original, ungrouped, raw data, you can use the Histogram
tool, or you could use my free Better Histogram add-in, available at
www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
Back
Top