Shading background of line chart

[dsforbes]

I have a chart that shows duration over the past 20 years plotted. I want to highlight/shade a specific area/region and can't figure out how to do it. I can highlight the entire plot area, but not a specific area. I tried adding a transparent text box and placed on top, but when I copy the graph elsewhere the object doesn't go with it.

The range is top .75 and bottom -.75 I want the range .45 to -.45 highlighted

Thanks.

 

[Andrew Poulsom]

Look here:

http://peltiertech.com/Excel/Charts/BackgroundFill.html

 

[dsforbes]

perfect, thanks so much