How do I create a trendline in a Microsoft Access Pivot Chart?

  • Thread starter Thread starter Mark from Oz
  • Start date Start date
M

Mark from Oz

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?
 
Back
Top