If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Gradient Line Chart not Working
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 |
#2
|
|||
|
|||
Gradient Line Chart not Working
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 |
Thread Tools | |
Display Modes | |
|
|