Hi,

I'm not sure how much control you have over the chart its contents and
the underlying data but one way of toggling a trendline between visible
and not is to add a second data series to the chart and base the trend
line on that. The second set of data would have identical data but be
formatted with no markers or line. The data for this extra series can
then have its X values set to those of the original data when you want
to see the trendline and NA() when the trendline is not required.

Cheers
Andy

Engin H. wrote:
Hi all
Is it possible to change visibility of Trendlines on a Scatter Graph?
i develop an app in .NET and need to make Trendlines visible or invisible by
user selection.
anybody have any idea to do this work?
Thanks a lot

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info