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

Mark from Oz

Guest

Posts: n/a

19th Mar 2010

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?

« creating report to print 4-up index cards on Avery 3381 | Re: SubReport ReportFooter not appearing »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Chart Trendline?	Ken	Microsoft Excel Misc	0	27th May 2010 10:57 PM
Automatically Add Trendline to Pivot Chart Query	ScottMsp	Microsoft Access Queries	0	15th Apr 2009 06:19 PM
Re: Pivot Chart trendline	Tushar Mehta	Microsoft Excel Charting	0	11th Jan 2007 02:51 PM
extra trendline on Pivot Chart	chankey@aegonusa.com	Microsoft Excel Charting	0	14th Jun 2006 06:37 PM
How do I add a Trendline to a Pivot Chart	=?Utf-8?B?TGVyb3k=?=	Microsoft Excel Misc	1	5th May 2004 01:21 AM