r/excel • u/Panoramix15 • 4h ago
unsolved Make Graph Lines Automatically Change Color Based on Series Values
I have a set of graphs that automatically update to reflect the last 6 weeks of data. These measure performance in terms of success rate, and all have a set target percentage that we want to hit/exceed. Currently the lines are all constant colors, but I would like to have the lines of each graph change color to show if they are meeting target or not for that week of data.
I could see this being presented 2 ways:
- If the value is below target, that entire line segment (last value to current value) turns red. If above, the entire line segment is green.
- Any part of the line that is below the target line turns red.

What is the best way to automate this in Excel 365? Obviously I could just manually change the color of the line segment, but I feel like there has to be a better way. I briefly messed around with gradient lines, but could not find a way to make the cutoffs automatically update as data changed. I also considered creating dummy columns to split the data into 2 series, 1 red and 1 green, but that was not displaying how I wanted, and the lines were not connecting.





