Are you looking for a tornado chart?
http://peltiertech.com/Excel/Charts/tornadochart.html
Even better would be a dot plot with two sets of markers:
http://peltiertech.com/Excel/Charts/DotPlot.html
The dot plot makes it easier to compare the values directly. A tornado moves
the values away from each other, and it's harder to tell which bar is
longer.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______