Hello
I'm trying to come up with a histogram chart that adjusts Bin Size based on user input. I've come up with the formulas for Bins and Frequency, but am struggling when it comes to charting the data to dynamically update when the user changes Bin Size. If anyone knows how to make the x-axis dynamically adjust with the number of Bins please help me out.
Thank you
~Bricks
This comes a little closer but drops off the last bin if it does not end right on Max([data]).
Why have the user enter the bin size rather than calculate the bin size based on the user-entered bin count and max and min data values?
Entia non sunt multiplicanda sine necessitate
Hi IcyBricks,
A Pivot Table can do this without any formulas. See the attached. You will simply need to change the GROUP bin size.
Read this site:
http://www.excelfunctions.net/group-pivot-table.html
Last edited by MarvinP; 07-02-2014 at 05:36 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
@MarvinP Thanks for the tip. I've never tried to group anything other than date/time or categories in pivot tables. Very cool! I was bummed to find you could not feed the "By" parameter a cell address but I wrote out the VBA for that:
@shg Point taken about user picking number of bins. In my code I let the user do either BinSize or #ofBins.
Please Login or Register to view this content.
If anyone has a non-VBA solution that does everything the attached workbook does I'd love to hear it.
This uses formula and named ranges to react to Bin Size. Same appraoch can be used for #Bins.
You might want to tidy it up so the last bin does not go beyond max data value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks