Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Histogram?

Haven't gotten a chance to post that one yet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike Middleton" wrote in message
...
Tom -

The usual chart type for a histogram is the Excel Column chart type.

Another possibility is the Histogram tool, part of the Analysis ToolPak
that ships with Excel. Choose Tools | Data Analysis | Histogram | Help for
details. (If Data Analysis is not an item on your Tools menu, see if it's
listed at Tools | Add-Ins and check the box. If it's not listed as an
available add-in, use your Excel/Office CD to install it.)

And, another possibility is my free Better Histogram add-in, available for
download from www.treeplan.com.

Jon Peltier, resident chart guru, may have his Even Better Histogram
approach available soon. Check his web site for histogram and other chart
information at http://peltiertech.com.

- Mike
www.mikemiddleton.com

"Tom" wrote in message
...
I'm trying to create a very basic chart type: a histogram. I'm amazed
that
there is no "histogram" type of chart already in Excel, but I can find
neither it nor any type that I could adapt to that application.

What I am trying to do is set-up some a series of bins, then look through
a
column of data to plot the frequency that the data within the range falls
into each bin as the height of the bars corresponding to the bins.

Has anybody already solved this problem?


Thanks,

Tom





 
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
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM
how to make a histogram with frequency hannah553 Excel Discussion (Misc queries) 1 January 15th 06 06:07 PM
Automatic Histogram with Inputs J Excel Discussion (Misc queries) 2 November 17th 05 07:56 AM
How do I create a histogram with no space between bars? Ann Charts and Charting in Excel 2 October 8th 05 11:12 PM
Charting cumulative values in histogram ? TonyB Charts and Charting in Excel 3 February 22nd 05 04:23 PM


All times are GMT +1. The time now is 11:54 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"