customizing charts
 

I am trying to customize a vertical bar chart, where the x axis is the areas
being measured and the y axis is the units of measurement. I have been
trying to shade a particular range within the overall plot area, not the
entire area. Specifically, the y axis range goes from 40 all the way to 160.
I just want to shade or fill in a specific range (85 to 115) within that
overall range. Is there a way to have that range (85-115) shaded only and
the other ranges (116 and higher, and 84 and lower) left untouched? Any help
would be appreciated. Thanks!

customizing charts
 

Hi,

The technique describe here will do it.
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ben" wrote in message
...
I am trying to customize a vertical bar chart, where the x axis is the
areas
being measured and the y axis is the units of measurement. I have been
trying to shade a particular range within the overall plot area, not the
entire area. Specifically, the y axis range goes from 40 all the way to
160.
I just want to shade or fill in a specific range (85 to 115) within that
overall range. Is there a way to have that range (85-115) shaded only and
the other ranges (116 and higher, and 84 and lower) left untouched? Any
help
would be appreciated. Thanks!