title: Histogram using Excel FREQUENCY function
body: <p>In Excel 2010, I have a list of values in column <code>A</code> and a bin size is specified in <code>B1</code>. This allows me to create histograms with N bins using this formula:</p>
  
  <p><code>{=FREQUENCY(A:A,(ROW(INDIRECT("1:"&amp;CEILING((MAX(A:A)-MIN(A:A))/B1,1)))-1)*B1+MIN(A:A))}</code></p>
  
  <p>The only problem is that I need to <em>select</em> N cells and apply this formula to get N bins to be used as data source for my bar chart. Is it possible to skip this step? E.g. Is it possible to use this formula in a single cell - somewhat modified - so that when used as data source, it is interpreted as N cells, producing a nice histogram with N values?</p>
  
  <p>Thanks.</p>
  
  <p><a href="https://stackoverflow.com/questions/9570168/generate-array-of-bin-sizes-in-excel">Here's the answer that led me to the formula above.</a></p>