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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 01: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 |