Inside Microsoft Office

Use the FREQUENCY function to create histograms that update with your data

Inside Microsoft Office

by Sean Kavanagh

Determining the number of times data items fall in certain value ranges, which is what a histogram accomplishes, can reveal more about a dataset than examining and charting all of the individual values. However, changes you make in the histogram’s input and bin ranges aren’t reflected in the histogram. Instead, you’re forced to re-create the histogram each time the data changes. In this article, we’ll show you how to use the FREQUENCY[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)