Hi Members, 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.
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. By 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 excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---