Why don't you use a scale break, you will have to show a number higher
than 20% though. Keep it a normal bar chart. Make the 51% bar go to a
second axis (which you will end up setting everyting in the patterns
tab to none). In the oprions tab (Format data series) set the overlap
100 and Gap width 60 - you may have to adjust the gap depending on how
wide your bars are. You can manually add breaks to the axis and the
single bar. Set you left scale from 0-22% and the right from 30-52%,
use this formula for the left custom number format axis ...

[=0.22]"52%"; 0%

This will show 52% instead of the actual 22%. If you send me your
email, I made a sample file I could send you.

Jim


--
Hackett
------------------------------------------------------------------------
Hackett's Profile: http://www.excelforum.com/member.php...o&userid=27039
View this thread: http://www.excelforum.com/showthread...hreadid=401186