>I need help in removing a trendline on my graph. I phyisically added the trend line in my ole control on my form. Now when I run the form the trendline displays. I can't seem to find the right syntax to add to the rest of my automation code to remove it.
>
>x123 = THISFORM.Olecontrol1.SeriesCollection(1)
>x123.Trendlines.Add(1) &&Adds the trendline
>
>But
>x123.TrendLines.Item(1).Delete &&Will not remove it
>
>And I can't find a way to remove it from the physical ole control either, just how to add one.
Steven,
Both:
x123.TrendLines.Item(1).Delete
and
x123.TrendLines(1).Delete
removes it for me.
Cetin