|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 24th, 2008, 12:09 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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! 
|
|
#2
September 24th, 2008, 12:19 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
