chart data line in two colors

#1 04-08-2005, 03:06 PM

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.

#2 04-08-2005, 03:06 PM

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

#3 04-08-2005, 03:06 PM

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

"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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)