How do I get a histogram using EXCEL

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
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Histogram And Bin Size ? 1
How do I create a Cumulative Frequency Histogram on Excel? 1
How do I create a CORRECT histogram? 1
histogram from weighted data 4
how do I draw a historgram? 2
Making Histograms 1
Can Excel draw a histogram with variable column widths 3
Histogram? 4

Top