LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default histograms in Excel

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



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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where to get Excel 2003 add-ins (Data Analysis/Histograms)? StormChaser Excel Worksheet Functions 2 October 5th 08 12:18 AM
Excel analysis should do proper histograms inc. bars touching Numskull Charts and Charting in Excel 3 June 23rd 06 06:07 AM
Histograms\Excel 2000 fjm Charts and Charting in Excel 1 October 3rd 05 08:18 PM
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM
In Excel 2003, the histograms are incorrect. Excel shows a bar gr. Levi Excel Discussion (Misc queries) 2 January 25th 05 03:17 AM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"