Multi-level Category Axis Fails with 100 rows of data
 

Hi there,

When working with mutli-level category axes I've noticed that 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.

For an example, here is a chart with a multilevel axis and 100 rows of data:
http://tinypic.com/view.php?pic=210nint&s=5

Here is one with one extra row (101 total):
http://tinypic.com/view.php?pic=2u721eg&s=5

As you can see most of the month lables and one of the year labels is
missing from the 2nd chart. I've put an excel file demonstrating the issue
here in case anyone is interested:
http://www.spunmonkey.org/Excel%202007%20Issue.xlsx

The same thing does not happen in 2003. Even if you save that file down to
xls, then open in 2003, it will display the axis correctly on both charts.

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.

Cheers,

V

Multi-level Category Axis Fails with 100 rows of data
 

I am having the exact same problem with my excel graph! Anyone find the
problem?

"V" wrote:

Hi there,

When working with mutli-level category axes I've noticed that 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.

For an example, here is a chart with a multilevel axis and 100 rows of data:
http://tinypic.com/view.php?pic=210nint&s=5

Here is one with one extra row (101 total):
http://tinypic.com/view.php?pic=2u721eg&s=5

As you can see most of the month lables and one of the year labels is
missing from the 2nd chart. I've put an excel file demonstrating the issue
here in case anyone is interested:
http://www.spunmonkey.org/Excel%202007%20Issue.xlsx

The same thing does not happen in 2003. Even if you save that file down to
xls, then open in 2003, it will display the axis correctly on both charts.

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.

Cheers,

V

Multi-level Category Axis Fails with 100 rows of data
 

nudging this one. I have been unable to find a fix for this. Anyone have any
information?

"J" wrote:

I am having the exact same problem with my excel graph! Anyone find the
problem?

"V" wrote:

Hi there,

When working with mutli-level category axes I've noticed that 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.

For an example, here is a chart with a multilevel axis and 100 rows of data:
http://tinypic.com/view.php?pic=210nint&s=5

Here is one with one extra row (101 total):
http://tinypic.com/view.php?pic=2u721eg&s=5

As you can see most of the month lables and one of the year labels is
missing from the 2nd chart. I've put an excel file demonstrating the issue
here in case anyone is interested:
http://www.spunmonkey.org/Excel%202007%20Issue.xlsx

The same thing does not happen in 2003. Even if you save that file down to
xls, then open in 2003, it will display the axis correctly on both charts.

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.

Cheers,

V