chart data line in two colors
 

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 ToolsOptions 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

"ReadyToLearn" wrote:

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.

Andy Pope has instructions for a conditional line chart:

http://www.andypope.info/charts/conditionalline.htm


ReadyToLearn wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html