PC Review


Reply
Thread Tools Rate Thread

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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 AM.