XL97: Changing Chart Type Changes X-Axis

 Last reviewed: January 15, 1998
Article ID: Q161660
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, when you change the chart type, the scale of the Category (X) axis may also be changed.

CAUSE

This 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:

  1. Select the X axis in the chart.

  2. On the Format menu, click Selected Axis, and then click the Scale tab.

  3. Select the "Value (Y) axis crosses between categories" check box, and then click OK.

STATUS

This behavior is by design of Microsoft Excel 97.

For additional information on this problem in previous versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q110856
   TITLE     : XL: Changing Chart Type Changes X Axis

REFERENCES

For more information about chart types, click the Index tab in Microsoft Excel Help, type the following text 

   changing chart types
and 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 : xlchart kbualink97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.