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

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?

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

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

beuchner wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

Thanks!

"Andy Pope" wrote:

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

beuchner wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

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

Mike

"Andy Pope" wrote:

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

beuchner wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

Hi,

One of these maybe better suited to your data.

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

Cheers
Andy

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

Mike

"Andy Pope" wrote:


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

beuchner wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info