Hi all,

I'm trying to make a Quality Chart showing how as time progresses the
defective % is beeing reduced. I wanted to make the line turn from red to
green with yellow in between to show the progress to acceptable levels so I
used gradient to achieve this, it works great, however the lowes secrion of
the trend line is allways green independent of the value. To fix this I added
a section of the line on dates outside the analysis range that went from 100
to 0, this too works but when I want to change the automatic date range to
hide this (100 to 0) section of the line the format changes and now it
applies the gradient individually to each point messing up the desired
effect. Is there a way to avoid this? It conciders the line as one line as
long as I keep the axis set to automatic, if a change them to fix (any of
them) it then goes point by point.

I should add that the line I want to apply this is on the secondary Y axis,
on the primary Y axis I have a bar chart and there is no secondary X axis.

I'm using Office 2007 and Windows Vista.

Thanks!
JS