How do I create a trendline in a Microsoft Access Pivot Chart?
in [Reports]
|
Prev: total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi
Next: SubReport ReportFooter not appearing
From: Mark from Oz Mark from on 19 Mar 2010 01:09 I have weekly revenue data in a table AND create a Pivot Chart. It shows the original data. I want to add a 6 week moving average as a separate line on the chart. In Excel I simply right click on the data series, select trend line, select moving average etc and it plots it. Besides creating another field, adding some code to calculate the 6week MA, is there a quick way in ACCESS 2007? |