Help with Conditionally formatted line graphs

My questions are listed in the attached workbook and also below.
--------
I'm in the process of creating a line graph that has varied color points based on their values. As of now, I have two separately plotted lines, and I want just one. The kind of graph that I want is similar to the XY/Scatter graph from this PeltierTech article. I'm just having trouble making sense of the last steps...

I have the difficult part setup, and it's just a matter of making a few tweaks, I think. See my attached Excel workbook.

Once I get this first chart completed, I'm going to need... about 30 more identical graphs, each with their own data sets that can be changed. What's the simplest way to do this in Excel 2000?

Thanks in advance!

I'm still not having a whole lot of luck figuring this out. I don't really need the labels to change color, so you can ignore that line in the Excel workbook. I just want to get the "dots" all on one line.

Duplication of the charts would also be extremely helpful.

If you can help answer either of those ?'s, that'd be awesome. Thanks!

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"