From: Juan on
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


From: PaulPW on
Hi Juan,
I've just now seen your post having posted a closely related problem on
4/30: see "Color gradient problem on X-Y chart".
Try setting your 2nd series to X-Y instead of Line.
I used the same technique as you to force the full gradient range to be
displayed across the Y-axis regardless of the range of my data (I added dummy
data from 0-100% of my Y-axis range at an X value outside of the 'max' value
on the chart).
My X-axis is times, not dates.

Paul

"Juan" wrote:
> 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
>
>