trend lines using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 27 Feb 2008 11:16 GMT

Hi:

I can create a standard graphic using Macro VBA language, but how can I
create trend lines? I want to "imitate" the trend lines wizard using my own
userform.

Thanks, Juan

Reply to this Message

news.microsoft.com - 27 Feb 2008 11:31 GMT

well, Now I Know how to do it :

Worksheets(1).ChartObjects(1).Chart. _
SeriesCollection(1).Trendlines(1).Type = xlMovingAvg

But....is this compatible with Office XP? I don't have it and can't probe
it..

Thanks
Juan

> Hi:
>
[quoted text clipped - 3 lines]
>
> Thanks, Juan

Reply to this Message