Frequency Distribution Chart in Excel using an Array Equation

Thanks! Share it with your friends!


This video shows you how to create a frequency distribution chart using an array formula.

there are a number of ways to create a frequency distribution chart in Excel, you can use a pivot chart, create a set of equations using countif or the method contained within this video.

You need to pay special attention at the part when the formula is copied down – the Ctrl Shift Enter combination is vital when you copy the equation.



Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.