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.

Hi

there might be a way to automate this, but i'm not sure how, but it is
possible to manually generate a chart where the line changes colour between
data points .... create the line chart as per usual, and then click on the
bit of the line you want to change colour (all the points should show as
selected) and then click again (only the points at the end of the line
you're clicking on should show as highlighted) now double click to bring up
the Format Data Point dialog, you can select the line colour for this bit of
the line via here - repeat for all the bits you need to recolor.

you might find other useful ideas that you can incorporate at
http://peltiertech.com/Excel/ChartsHowTo/index.html

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"ReadyToLearn" wrote in message
...
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.

Ready,

Here's another approach. You can color above and below your goal value. Or
put a horizontal line to indicate your goal, using another series. Post
back if you're interested.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"ReadyToLearn" wrote in message
...
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 have a couple of answers in the microsoft.public.excel.charting
newsgroup too.


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