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!