LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Histograms: how change number of bins

This is a question about the Histogram Data Analysis tool.

By default, Excel seems to apply some (unclear) heuristic
for determining the number of bins.

Is there an easy way for me to force the number of bins
to be N?

The operative word is "easy".

I know that the tool allows me to specify a "bin range",
a range of cells that specify the lower bound of each bin.

But that seems "hard" for me use because the range of data
cells change, based on the number of data points I want to
include in the histogram.

I might (please confirm) be able to assign an array name
to a data cell range, then constuct an N-cell bin range
that uses the min() and max() of the array name. By
reassigning the array name to different data cell ranges,
the bin range values should change automatically.

But it would be "easier" if the histogram tool allowed me
to simply specify the number of bins, and the tool computed
the lower bound based on the data range, as I would.

I am looking for something that "easy". Since the need
seems so "obvious" and "common", I suspect I am simply
failing to see how to do it.

 
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 do I change a large number of cells from a postive to a neget. bmordy Excel Discussion (Misc queries) 6 January 5th 05 09:42 PM
How do you change the date to a Number help me Excel Discussion (Misc queries) 8 December 15th 04 07:54 AM
How do i change numbers in text format to number format? Greg New Users to Excel 1 December 14th 04 05:22 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM
EZ Q 4 U: How do I change a number to text, based on the number UCD GRAD Excel Worksheet Functions 2 November 9th 04 09:05 PM


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