title: How do I programmatically change the line colour for a series in a chart in Excel 2007
body: <p>I have a chart with a series that denotes a large set (1000's) of discrete measurements. Some of these are bad measurements and I want to colour the line for the series based on another set of data that describes how accurate the measurements are. Bad measurements should be red and good measurements green and the in between on some kind of gradient from red to yellow to green. </p>
  
  <p>This should be able to be programmed with VBA however I have no idea what to do. Can anyone give me some hints?</p>