Possible to change object properties from within expression?

[#1]

My meaning is rather than having to write a macro.

For example, on a trendline in a chart, if my formula equates to zero, is there a way to set the "Enable" or "Invisible" property of the trendline without writing it in VB/macro? I'm currently handling these situations via macro, but in some instances it would be much simpler to handle as part of the trendline expression.

Any help is appreciated!

Thanks, Dave

[rwunderlich]

You can't access properties directly from an expression, but many screen elements have a conditional show property or color that can be used to show/hide. For Trendline, switch instead to using a Reference Line (in Presentation). Reference lines have a conditional show property available.