Penny -

1. Do the rows have to total 35? I am guessing they could total to
anything as long as they were the same in each row.

Your guess is correct.

2. I like having the separation between the two sets of categories (one
jetting to the left and one to the right). However, I also need the X axis
to be shown. With the 100%stacked bar chart, the axis become percentages. I
lose the numbers. Any help here?

You will have to build your own dummy axis:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______