V
V
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 2007 Issue.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
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 2007 Issue.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