XL: Changing Chart Type Changes X Axis

ID: Q110856

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, when you change the chart type for a group, the scale of the x axis may change as well.

CAUSE

Choosing a group and changing the Chart Type is different from selecting a single series and then changing the chart type. When you change the chart type for a group, you may change some of the x axis settings for the chart.

This behavior is by design in Microsoft Excel version.

RESOLUTION

Select the series on chart first, then change the Chart Type using the Chart Type command on the Format menu.

REFERENCES

"User’s Guide," version 5.0, pages 282-283, 334

Additional query words: MS Graph incorrect wrong

Version           : WINDOWS: 5.0, 5.0c, 7.0, 7.0a; MACINTOSH: 5.0, 5.0a
Platform          : MACINTOSH WINDOWS
Issue type        : kbprb

Last Reviewed: May 16, 1998