This is an old revision of the document!

Excel Hints

Creating a histogram

How did microsoft manage to make this difficult?!

  • Manually type a list of number that will be used for binning the data.
  • Next to the column of bin numbers, select the cells that will be filled with frequency counts.
  • Type a formula “=FREQUECNY(…,…)” and select the appropriate data and bin numbers.
  • Type “Ctrl+Shift+Enter” so that the formula get applied to the array.

QR Code
QR Code excel (generated for current page)