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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Pivot Chart Trendline? 0
Trendline Not Appearing In Chart Problem ? 0
Trendline Showing Problem ? 3
Trendline in Stacked Column Chart 2
Trendline partial data 2
Access Pivot chart in Report 2
Data points in chart incorrect 0

Top