Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Histogram tool
Hi, I have following bins of horizontal histogram axis: 0,2 0,4 0,6 0,8 1,0 etc. Each value that is not exactly the same as mentioned bins, e.g. 0,23, Histogram tool puts into an interval "More" and count its frequency separately. How can I force Excel count value 0,23 in the interval 0,2-0,4 and not in interval "More"? Thanks for your help. -- balcovja ------------------------------------------------------------------------ balcovja's Profile: http://www.excelforum.com/member.php...o&userid=26239 View this thread: http://www.excelforum.com/showthread...hreadid=398524 |
#2
|
|||
|
|||
It is unclear how you arrived at this situation. When I specify similar
bin ranges, the ATP Histogram tool does for me what you say it doesn't do for you. You could fix up the table and resulting graph after the fact by replacing values with appropriate COUNTIF formulas. Jerry balcovja wrote: Hi, I have following bins of horizontal histogram axis: 0,2 0,4 0,6 0,8 1,0 etc. Each value that is not exactly the same as mentioned bins, e.g. 0,23, Histogram tool puts into an interval "More" and count its frequency separately. How can I force Excel count value 0,23 in the interval 0,2-0,4 and not in interval "More"? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Free Data Process/Query Tool | New Users to Excel | |||
Free Data Process/Query Tool | Excel Discussion (Misc queries) | |||
Free Tool (Add-in) To Speed Up Your Data Processing | Excel Worksheet Functions | |||
Excel Tool Bar Gone | Excel Discussion (Misc queries) | |||
Charting cumulative values in histogram ? | Charts and Charting in Excel |