View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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!