Hi all,
As I'm revising and even recreating some of my data sheets, I'm curious if there are better and/or easier ways to create histograms than my current procedure. The way I set up my sheets is this:
1. Create bins manually.
2. Do a frequency count on my data referencing the bins.
3. The frequency count is regulated with OFFSET allowing for a dynamic lookback period.
4. Histograms are created using the frequency count.
I'm attaching both picture and workbook sample.
I just realized that I can create histograms automatically in Excel. At first, I felt a bit stupid realizing this, but I also see that there's problems with this. For one - I guess I can't have a dynamic lookback period as I've accomplished. Also, no control on the bin sizes?
Anyway, I have many such sheets to make, so would be grateful for any comments. Maybe the way I currently do it is the way to proceed.
Thanks in advance!
Skjermbilde.PNG
Bookmarks