Create a solution region on a chart
I'm creating a graph of a linear inequality. I have to plot two lines, then
show the solution region, or a shaded region between the two lines. So in effect I need to be able to shade a portion of the chart from the Y and X axis and the two lines that I plot. How can I shade a specific region on a chart? |
Create a solution region on a chart
Hi,
First try - Use a stacked line chart. If you don't get any satisfactory answers and the above does not work send me a sample: I'll look at it tonight. -- Thanks, Shane Devenshire "WACKEY" wrote: I'm creating a graph of a linear inequality. I have to plot two lines, then show the solution region, or a shaded region between the two lines. So in effect I need to be able to shade a portion of the chart from the Y and X axis and the two lines that I plot. How can I shade a specific region on a chart? |
Create a solution region on a chart
WACKEY -
One approach is to use wide-formatted custom error bars (based on worksheet calculations) with lots of points on an XY (Scatter) chart type. For a somewhat-relevant example, see http://www.mikemiddleton.com/ShadedNormalDensity.xls - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "WACKEY" wrote in message ... I'm creating a graph of a linear inequality. I have to plot two lines, then show the solution region, or a shaded region between the two lines. So in effect I need to be able to shade a portion of the chart from the Y and X axis and the two lines that I plot. How can I shade a specific region on a chart? |
Create a solution region on a chart
Hi,
Depending on you chart you maybe apply to use extra series plotted as area to provide the shading. http://www.andypope.info/ngs/ng21.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "WACKEY" wrote in message ... I'm creating a graph of a linear inequality. I have to plot two lines, then show the solution region, or a shaded region between the two lines. So in effect I need to be able to shade a portion of the chart from the Y and X axis and the two lines that I plot. How can I shade a specific region on a chart? |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com