Thread: How do i show the gap between two lines of a chart
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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

Reply With QuoteReply With Quote