When working with multi-level category axes Excel 2007
incorrectly displays the axis when there are more than 100 rows of data
included in the chart. Many of the labels are not displayed.

"V" provided a couple of examples
- a "correct" multilevel axis and 100 rows of data:
http://tinypic.com/view.php?pic=210nint&s=5
- an incorrect chart is one with one extra row (101 total):
http://tinypic.com/view.php?pic=2u721eg&s=5

Any ideas as to how to get around this in Excel 2007 would be appreciated,
as I use these multi level category axes a lot.

(Thanks to "V" for the original post and clear examples)