View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default How do I get a histogram using EXCEL

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


"ngwenya" wrote in message
...
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