The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you change the chart type, the scale of the Category (X) axis may also be changed. CAUSEThis problem occurs when you select a series and change its chart type. Changing the chart type for a series is different from changing the chart type for a group of data points. Based on the chart type you select, the "Value (Y) axis crosses between categories" check box may be cleared in the Format Axis dialog box. WORKAROUND
To work around this behavior, follow these steps:
STATUSThis behavior is by design of Microsoft Excel 97. MORE INFORMATIONFor additional information on this problem in previous versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base: Q110856 XL: Changing Chart Type Changes X Axis REFERENCESFor more information about chart types, click the Index tab in Microsoft Excel Help, type the following text changing chart typesand then double-click the selected text to go to the "Select a Different Chart Type" or "Change the Spacing of Tick Marks and Labels on the Category Axis" topic. Additional query words: XL97 8.00 ms graph incorrect wrong
Keywords : kbualink97 kbchart |
Last Reviewed: November 8, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |