Change Tendline in VBA

[spongie1]

I am still pretty new to Access and VBA.

I am displaying a query as a pivot chart. The query is based off of a query that I have constructed already. (I still don't know all the syntax for creating a query completely from scratch.)

I modify the query with an SQL statement that I build in VBA which takes information from a form.

Currently, all of the pivot chart setup is done in my already existing query (not generated via vba).

I want to modify certain aspects of the pivot chart in vba. Where can I look to get this information. I am so new, I do not know where to look or what to look for...

On thing that I am trying to do is change the trendline. Currently, it is set as a 4 week moving average. I want to change it in vba to a x week moving average where x is defined in a form.

If someone can explain how to modify pivotcharts in vba or knows of a good data source... or can get me pointed in the right direction... I would be enternally grateful.

Thanks,

Jason

 

[sfm6s524]

Sounds like you could use the Microsoft Graph VBA help file:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;128364

By default, the Graph help doesn't display in Access, but the VBA_GRP.HLP has what you need, including the Trendlines object.

 

[spongie1]

Thank you for the link. That information was enough to get me pointed in the right direction. I am currently reading the help. I have also found a link to an article titled:

Formatting Access 2002 PivotCharts with VBA

http://msdn.microsoft.com/library/d...y/en-us/dnoffpro01/html/OfftheChartAccess.asp

This article promises to teach me everything that I asked wanted to know about the basics of editing my pivotcharts.

Thanks again for pointing getting me started.

I have posted the link. I am sorry that I mispelled trendline in the original post.

Jason