I have been searching for this in the forums and Google and either the answer is not out there or I just cant find it.
What I am trying to do is color a graph with a trend line based on whether the trend line is going up or down. A period of time is the X axis and value is the Y axis. The trend line appears to be working correctly for the graph points for the period of time being used. What I would like to do is set the color of the graph to either be Red if the trend is going down or Grey if the trend is going up.
Each point in the tooltip I can color based on the goal for each point (weekly) on the graph, but for the trend line it doesn't matter if the goal was reached or not it is just dependent on if the trend is getting better (up) or getting worse (down).
I wouldn't think this would be that hard to do but I don't see any thing that lets you do this. The goal part has somewhat complicated calculations to it but for the trend it is really just up is good down is bad and corresponding color. I am thinking I am just missing something obvious on this.
That's a good idea! Let me know how it goes. And appreciate if you can close this thread by marking either my response or your own response as the best and upvote them too.
