title: Color chart lines based on cell value not associated with chart
body: <p>I am looking to find an automated way to color lines on a chart in excel based on a value and/or a color from a cell not associated with the chart itself.  Color based on value being the ideal solution.</p>
  
  <p>The data for the chart at the link below is in cells B2:F9 and the colors I want represented are on lines C1:F1.  Based on this image, I want the chart line representing rows C and E to be green and the chart line representing D and F to be red.  </p>
  
  <p><img src="https://i.stack.imgur.com/rBHYL.png" alt="enter image description here"></p>
  
  <p>In order to color the pass/fail section I currently have conditional formatting setup but am able to change this for a more effective solution.  This needs to be scaled across a large number of reports so manual color changing is not a viable option.</p>
  
  <p>Any assistance would be greatly appreciated.</p>