How do i show the gap between two lines of a chart

[Guest]

Very simple question. I have a two line graph that I made in Excel. I want
to shade just the area between the two lines wherever they diverge. Does
anyone know how to do that?

 

[Andy Pope]

Hi,

The trick is to use area charts to provide the shading. This requires
adding additional series. See this example.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

 

[Guest]

Thanks!

Hi,

The trick is to use area charts to provide the shading. This requires
adding additional series. See this example.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

 

[Mike]

Cool trick. Works well with straight line series. Is there a more elegant
solution for non-linear series?

Mike

 

[Andy Pope]

Hi,

One of these maybe better suited to your data.

http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy