Vista Forums - View Single Post - Problems creating trendlines in powershell-created excel chart

M. Capel · 10-12-2008

Thanks folks,

One small thing...the sixth arg in the Trendlines().Add() must be $False to avoid forcing the y-intercept to 0.

Or to be brutally explicit:

$ac.SeriesCollection(1).Trendlines().Add(-4132,4,0,0,0,$False,$True,$True,'Serie*1Trend1')

10-12-2008	#5 (permalink)
M. Capel Vista Ultimate x64 2 posts	Re: Problems creating trendlines in powershell-created excel chart Thanks folks, One small thing...the sixth arg in the Trendlines().Add() must be $False to avoid forcing the y-intercept to 0. Or to be brutally explicit: $ac.SeriesCollection(1).Trendlines().Add(-4132,4,0,0,0,$False,$True,$True,'Serie*1Trend1')
My System Specs