Creating a Histogram with a User Defined Number of Buckets

By Dany Hoter Intro by Avi: I have often been asked, about ways to provide an “input” to the Power Pivot model from Excel. Disconnected Slicers are a popular way to do this. But with Excel and Power Pivot, there is always more than one way to accomplish a task. Dany shows us how, while making histograms easier to use. He uses a filter dropdown, which even works with Excel Online – inside a browser! Here is the end result, read on to learn how and download file. Take it away Dany… Introduction Creating a histogram in Excel based on Power Pivot is not as easy as it should be. The method I use is no different from what others have already blogged and wrote about. There is even a solution that calculates the number of bins in a histogram with a formula that is based on the total number … Continue reading Creating a Histogram with a User Defined Number of Buckets