Is it Possible to Conditionally Format a Line Graph?

[TheXxvI]

Good morning,

I have a line graph that has varying levels of slopes. I was wondering if there was a way to conditionally format the line to show more green the more the slope is flat, show more red when the slope is very steep, and yellow/orange when it's about halfway in between. Is this possible?

Thank you in advance!

Cory

 

[jorismoerings]

Try Conditional Charts Conditional Formatting of Excel Charts - Peltier Tech Blog

 

[TheXxvI]

Unfortunately, that's not going to work. I saw that before but it needs to be dynamic. Any other suggestions?

 

[jorismoerings]

maybe but will need a sample of your data to play with to check if my idea works.

 

[TheXxvI]

Here's an example of what it could look like:

Player A - 108.4
Player B - 106.8
Player C - 102.0
Player D - 99.9
Player E - 86.4
Player F - 86.2
Player G - 86.1
Player H - 84.1
Player I - 78.1
Player J - 77.9
Player K - 76.8
Player L - 74.0
Player M - 69.8
Player N - 69.4