histograms in Excel

  • Thread starter Thread starter Texas Tonie
  • Start date Start date
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
 
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

how to calculate histogram from yearly dataset 1
Creating a histogram and line on the same chart 1
Histogram Question 2
Continuous data in a histogram 1
Histograms...and buttons 1
Histogram 4
Histograms 2
Creating a distribution chart 5

Back
Top