Possible to change object properties from within expression?
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.
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.
