Shading in Chart
 

I have a column chart with the axis from +30% to -30%. I want to highlight
the columns that fall outside of the 5% range. Is there a way to shade the
plot area from +5% to -5% in gray? Hoping I am clear. Thank you.

Shading in Chart
 

Hi,

You can additional series to provide the shading.
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy

Chris wrote:
I have a column chart with the axis from +30% to -30%. I want to highlight
the columns that fall outside of the 5% range. Is there a way to shade the
plot area from +5% to -5% in gray? Hoping I am clear. Thank you.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info