Multi-level Category Axis Fails with >100 rows of data

J

jonS

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-level Category Axis Fails with >100 rows of data 2
Multi-Level Category Labels 1
Using the full width of an Excel chart with two Y-axes 2
Multi-level Category Axis Fails with >100 rows of data 4
Scatter Plot Chart with Category 3
I cannot set the maximum date for the axis of a line chart 5
Multi-Level Category Gridlines 3
Line chart - time series - category axis date format (2007 VBA) 1

Top