Conditional format Chart :Colors.

**JapanDave** · 03-22-2013, 10:51 PM

Can someone show me how I could do this to a Series Graph?

graph.jpg

**Pete_UK** · 03-23-2013, 08:53 AM

Hi Dave,

Andy Pope has something like that here:

http://www.andypope.info/charts/conditionalline2.htm

Hope this helps.

Pete

**JapanDave** · 03-25-2013, 06:39 AM

Thanks, that helps. Is there a way of having blend instead of changing abruptly into another color?

**Pete_UK** · 03-25-2013, 06:51 AM

Don't know - maybe send Andy a PM directly?

Pete

**Andy Pope** · 03-25-2013, 07:10 AM

You would need to determine the point before the intersection and the intersection point and then format that to have a gradient fill between the 2 relevant colours. So you would need a set of points for above > below and below > above.
The length of the blend of colours would depend on your data points and may look distorted and confusing.