Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Histogram?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Histogram?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Histogram?
On Thu, 25 May 2006, in microsoft.public.excel.charting,
Tom said: 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. It is amazing, isn't it? It's part of how Excel is just generally weak on statistics graphing. There's no built-in box-and-whisker plot either (don't get me started on how badly Pivot tables support medians, quartiles, etc.) There are some tools in the Data Analysis Pak add-in, but they're not worth much. Use the COUNTIF() function to make a table based on the data set, then plot that range. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Histogram?
"Mike Middleton" wrote in
: 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 Thanks, Mike. I tried both. I like yours better. --Tom |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel | |||
how to make a histogram with frequency | Excel Discussion (Misc queries) | |||
Automatic Histogram with Inputs | Excel Discussion (Misc queries) | |||
How do I create a histogram with no space between bars? | Charts and Charting in Excel | |||
Charting cumulative values in histogram ? | Charts and Charting in Excel |