View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jonny Jonny is offline
external usenet poster
 
Posts: 25
Default Conditional formatting of lines in a chart

Is there any way that one can change the color of a line in the chart
depending on the value of some other cell in the spreadsheet e.g., if a
certain condition is true, the line (or point on the line) is blue and if it
is false the line (or point on the line) is red.