This video takes monthly US Retail Sales data from Jan 01 - Jun 06 and makes a percent histogram out of it. I emphasize the danger of making cross-sectional displays out of time-series data as one loses all time patterns.
@SweetandSaltyNutbars In Excel once you start a pattern with 2 values, Excel predicts the next values in the series based upon your pattern. For determining the number of bins and bin range (width), I use approximately the square root of the sample size to determine the number of bins, then I try to choose nice, whole numbers -equally-spaced, of course - that will give me the number of bins I desire (or close to it).
Thank you so much for this brilliant video. I have a little problem though, I am not able to update the chart with a new data afterwards. Do I have to go through this process everytime?
How did you automatically input the number by intervals of 40 at the beginning? also is there a formula you can use to find bin range with your observational data?