Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.