If you have appreciated the time and effort that has gone into providing this site, you may wish to assist us by making a PayPal donation towards its running costs.
How to build Box-Whiker Charts.
Uses a scatter chart to build box-whisker.
One of my gripes when charting time series is that many people use simple moving averages to smooth data. A moving average does not reflect the underlying data as well as it is commonly supposed, and should always be shown together with the original data.
This add-in builds a 13-point Henderson filter. It is used to smooth monthly data that has annual periodicity. This method is preferred over a 13-month moving average, because it utilises lower weighting for the end-points of a time series. The resultant smoothed series shows turning points more accurately, and is better able to capture series maxima and minima.
The Henderson filter is the starting point for X-13 series decomposition as used by Government statistics bodies. Try it for your monthly data.
A waterfall chart built using scatter charts instead of the more common stacked column chart.
See my blog for more details.
This shows how to use a Pivot Table to build a balance sheet. The nice thing about this is that the Balance Sheet is interactive, it allows drill-down and can show multiple periods together for comparison.
Just add your own Chart of Accounts and some data.
