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, Jay --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
