Shaded Control Chart in XL2K 1

[MeGustaXL]

Hi All,

Does anyone know how to create a chart like a Control chart, but with the area between the Upper and Lower Control Limits shaded?

I'm sure I've seen this on an Excel Guru's website, but I'm danged if I can find it!

Chris

Varium et mutabile semper Excel

http://www.insys-ltd.co.uk

 

[AndyPope]

Hi,

You can create the shaded effect by using 2 extra data series plotted as an area chart.
There is an example here.

http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

 

[MeGustaXL]

Thanks Andy, that's exactly what I wanted! ==>*

I knew it was on an XL Guru's website, but to my shame I'd lost the link to yours, of all people!



Chris

Varium et mutabile semper Excel

http://www.insys-ltd.co.uk