Is it possible to change visibility of Trendlines on a Scatter Gra

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
It seems all you can do is create and delete it based on the selection.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
jon
thanks for your reply
i also think it is the one way to do this job
i did it, it works fine, but with bad performance :(
Engin H.
 
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
 
Back
Top