Microsoft Office Tutorials and References
In Depth Information
Other Trending Techniques
In this example, the second row of the smoothing column contains a simple average formula that
averages the first data point and the second data point. Note that the reference to the first data point
(cell D2) is locked as an absolute value with dollar ( $ ) signs. This ensures that when this formula is
copied down, the range grows to include all previous data points.
Once the formula is copied down to fill the entire smoothing column, it can simply be included in the
data source for the chart. Figure 8-35 illustrates the smoothed data plotted as a line chart.
Figure 8-35: Plotting the smoothed data reveals the underlying trend.