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

Creating a histogram and line on the same chart 1
Creating a distribution chart 5
Kurtosis function 3
macros in Excel 2007 1
Reshaping histograms 4
outliers/histograms 1
Excel Weird Excel 2003 error 0
dates are reversed in my chart 2

Top