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!

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!