• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Exponential Smoothing Formula

K

Kamarlon

New Member
I have a dashboard where I forecast KPIs for the coming month. I have decided that exponential smoothing is the best forecasting technique to use. Problem is exponential smoothing provided by Excel in Data Analysis is not dynamic. Hence when I select the various KPI it is not updated. Without having to use VBA does anyone know how to write a formula to get exponentially smoothed data that changes as the KPI is selected?
 
You could write this projection yourself in another row and link the graph to it. Your particular exponential smoothing is best applied by you, since you know your data. To make it work, check out the Dynamic Charts article on this site (or something similar to that name).
 
You must log in or register to reply here.
Back
Top