Sales, marketing, and customer data can be so erratic that it’s hard to see patterns in your Excel chart or dashboard. With a couple of easy techniques and formulas you can smooth your data to make those hidden patterns visible.
The easiest smoothing technique is the moving average. For example, instead of showing the current month’s data you show the average of the current and last two months. In the following figure the formula in cell G22 takes an average of the current month in G20 and the previous two months F20 and E20.
Copying the formula in G22 across the row produces smoothed data that can be charted.