Guys, I'm in the following situation: I have a column with data, based on which I need to generate a histogram. To generate a histogram I need:
- Bins, which will have to be generated by Data Analysis toolkit, since my bins are dynamic and I can't really fix them (e.g. via intervals of tens, etc.)
- Frequency count for each bin, which is easy let's say
Now, frequency part I can easily automate via =FREQUENCY function, so let's say that's covered. Now, the question(s):
1) Is there a way (e.g. like in the case of frequency) to come up with a formula that would automatically give/create bins from source data?
2) If not, is it possible to automate bins generation via a macro which would use the Data Analysis Toolpak functionality? (or both bins and frequency, if necessary)
I need to automate bins generation/regeneration, because once the source data is updated, the bins will (and should) change. So that's why I need to get it done.
Any ideas, good people?![]()
Bookmarks