| Home |
| Search |
| Today's Posts |
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Linear Mode
