| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Can I show 3 different lines in one chart? | Charts and Charting in Excel | |||
| Using drop lines with XY scatter chart | Charts and Charting in Excel | |||
| Horizontal lines in waterfall chart | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) | |||
Linear Mode
