histograms in Excel

T

Texas Tonie

i have a large amount of numbers that i want to make a histogram distribution
of.

how can i create a histogram distribution plot in Excel quickly?

Texas Tonie
 
M

Mike Middleton

Texas Tonie -

(1) Use the Histogram tool of Excel's Analysis ToolPak. See Help for info,
or tell us what version of Excel you're using.

(2) Use my free Better Histogram add-in, available from www.treeplan.com.

Or, if you're willing to forego "quickly," use worksheet functions like
FREQUENCY or COUNTIF to get the frequency distribution, and then create a
Column chart type for the histogram.

- Mike

http://www.MikeMiddleton.com
 

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

Generating manpower histogram 0
Creating a histogram and line on the same chart 1
Reshaping histograms 4
Histogram, And "Normal" Curve For ? 1
Creating a distribution chart 5
Kurtosis function 3
How to add a normal distribution to a histogram 0
Histograms Error 0

Top