chart data line in two colors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My boss wants a data line in my chart be green when abouve goal and red when
below goal. I do not think it is possable, but I thought I would check out
here first.
 
You could try making a second series column containing only the values that
are above target, leave the other cells blank. Check under Tools>Options in
the Chart section to make sure blank cells are not plotted and plot both
series, you should be able to get the 'above target' series to sit on top of
the 'all values' series and give it a different colour to achieve the effect
you want.

Andrea Jones
 
Back
Top