A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Gradient Line Chart not Working



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2010, 07:27 PM posted to microsoft.public.excel.charting
Juan
external usenet poster
 
Posts: 77
Default 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


Ads
  #2  
Old May 21st, 2010, 04:16 PM posted to microsoft.public.excel.charting
PaulPW
external usenet poster
 
Posts: 3
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.