Help with Conditionally formatted line graphs

Alright I figured out my main problem. I realized I'm more or less plotting the % < 2, the % >=2, AND the %. Then I just had to hide the lines of the 1st two and hide the plot points of the last.

I'm going to start a new topic for the 2nd part of my question for organization's sake.

As you worked out you need to plot the line for all the points, without data markers.

The Y axis can be done with a custom number format. Format axis as Green then use,

[Red][>0.02]0.0%;0.0%

Originally Posted by Andy Pope

The Y axis can be done with a custom number format. Format axis as Green then use,

[Red][>0.02]0.0%;0.0%

Works perfectly, thanks!

Out of curiosity, what do each of those numbers/signs mean?

The help explains the construct of the number format better than I can.

Press F1 and search for the term "Create or delete a custom number format"