shading difference between two series

Y

ybufalo

Hi,

i'm trying to create a chart that has two data series Y1 and Y2
Whenever Y1 is greater than Y2 I want to shade that region with on
color lets say blue. Whenever Y1 is Below Y2 I would like to share th
region with another color i.e red. Is there any way to do this? I'v
tried duplicating the Y1 and Y2 series and then doing an area fill o
the two new added series but I'm left with an area fill below th
intersection of these two lines that I dont want.

thanks,

Da
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do pair different data series. 1
Convert Error Bars to Series and Colour 1
Two color fill between two lines 8
XL 07 - add color to specific part of plot area 1
Shading a range between two series in a chart 1
Shading between 2 lines 1
How To Modify One Point In A Graph... 3
How do I shade the area between two lines on a chart? 3

Top