trend lines using VBA

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

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
 
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
 
Back
Top