A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2005, 01:15 PM
Engin H.
external usenet poster
 
Posts: n/a
Default Is it possible to change visibility of Trendlines on a Scatter Gra

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
  #2  
Old June 25th, 2005, 02:57 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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/
_______


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

  #3  
Old June 25th, 2005, 03:07 PM
Engin H.
external usenet poster
 
Posts: n/a
Default

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.


"Jon Peltier" wrote:

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/
_______


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


  #4  
Old June 25th, 2005, 04:02 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell shading whenever contents different from previous cell zooeyhallne General Discussion 3 June 6th, 2005 09:59 PM
conditional cell shading when a change occurs zooeyhall General Discussion 1 June 6th, 2005 05:14 PM
After change of daylight saving time all meetings one hour back! dellborg Calendar 0 November 8th, 2004 02:49 PM
how do I change button color Vivacious-Lady Database Design 1 October 18th, 2004 05:21 PM
A change of track changes Lorrie Formatting Long Documents 1 June 12th, 2004 02:32 AM


All times are GMT +1. The time now is 06:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.