Chart on Enclosed Area by 3 Linear Equations

[booyaolian]

Hi guys,

how would you create a chart that shows a shaded area that's enclosed by 3 linear equations?

(1) Y = (-5/4) X + 500
(2) Y = 400
(3) X = 300

Any help would be greatly appreciated!

Btw, I'm using either Excel 2007 or Excel 2010.

Thanks in advance!

[booyaolian]

BUMP!

Is there any way I can get the enclosed area shaded?

[Andy Pope]

You need to construct shaded area using series plotted as area. Probably requires 2 series, one to position the actual area used for shading.

Alternatively use a shape, of course this will not be dynamic.