Microsoft KB Archive/834579

= Some category labels are missing or are too small to read on Excel charts =

Article ID: 834579

Article Last Modified on 1/11/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



SYMPTOMS
When you view a Microsoft Excel chart that contains labels on the Category Axis, one of the following issues may occur:
 * Some of the labels may be missing (such as every other label).
 * The labels may be too small to read.
 * The labels may be run together (overlap).



CAUSE
This issue may occur if one or more of the following conditions are true:
 * The frequency of the major units on the Category Axis is not set to display every major unit.
 * The font size is too small for you to read the labels on the Category Axis of your Excel chart.
 * The font size is too large for Excel to display all the labels correctly on the Category Axis of your Excel chart.



WORKAROUND
To work around this issue, change the major unit and change the font size of the labels for the Category Axis in your Excel chart. To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007
 Start Excel, and then open the workbook that contains the Excel chart. Right-click the Category Axis that is contained in the Excel chart, and then perform one or both of the following actions:  Click Format Axis, and then follow these steps:  In the Format Axis dialog box, click Axis Options. Next to Major Unit, click Fixed, and then type 1 in the Fixed box. Click Close.</ol> </li> In the Font box, choose a different font size to use for the labels in the Category Axis.</li></ul> </li></ol>

Microsoft Office Excel 2003 and earlier versions of Excel

 * 1) Start Excel, and then open the workbook that contains the Excel chart.
 * 2) Right-click the Category Axis that is contained in the Excel chart, and then click Format Axis.
 * 3) In the Format Axis dialog box, perform one or both of the following actions, and then click OK:
 * 4) * On the Scale tab, click to clear the Major unit check box, and then change the major unit to 1.
 * 5) * On the Font tab, select a different font size to use for the labels in the Category Axis.

Additional query words: xl97 xl2000 xl2002 xl2003 excel97 excel2000 excel2002 excel2003 excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 xlchart excelchart

Keywords: kbtshoot kbchart kbexpertisebeginner kbprb KB834579

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.