How to change color of Area Series based on Bar Series values
Good morning, all!
I have a bar chart that also includes a secondary Area Series (see pic). The Bar Series tracks daily count of safety conversations our employees do. We are required to do at least 80 over the course of a week. Basically, if we do 12 per day, we would be safe to reach our goal. What I would like to do, is to have the Area Series change from grey to yellow in color if we fall below the average at any time. So, if we're below 12 on Monday, yellow, if we're at 25 on Tuesday, grey, and so on. Any time the count gets to 80 or above, it would go to grey regardless of the day. Any thoughts on how to script this?
Thanks in advance for the help!!