Microsoft KB Archive/109426

Microsoft Knowledge Base

XL5: X Values Tab May Be Missing from Chart Format Dialog

Last reviewed: September 13, 1996
Article ID: Q109426

The information in this article applies to:

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

SUMMARY

When you format charts in the versions of Microsoft Excel listed above, the X Values tab will not appear in the Format Data Series dialog box unless the current series is the first series in the chart or the first series in the current group.

This is by design.

MORE INFORMATION

To access the X Values tab when you format a chart:

1. In the chart, select the first series ("S1") or the first series in a group. For example, if you have three series in a line group, select the first series of the three. (To select a series, click it with the mouse.)
2. From the Format menu, choose Selected Data Series.
3. Select the X Values tab.

You can now change the x values for the current chart.

Steps to Reproduce Behavior

1. In a new worksheet, enter the following values:

      A1: 1   B1: 5
      A2: 2   B2: 6
      A3: 3   B3: 7
      A4: 4   B4: 8
   

2. Select the range A1:B4.
3. From the Insert menu, choose Chart, and then choose As New Sheet.
4. In the ChartWizard dialog box, choose the Finish button.
5. In the new chart, select the second series (S2).
6. From the Format menu, choose Selected Data Series.

Note that the X Values tab is not present.

1. In the Format Data Series dialog box, choose Cancel.
2. Select the first series (S1) in the chart.
3. From the Format menu, choose Selected Data Series.

The X Values tab is now accessible.

KBCategory: kbusage KBSubcategory: Additional reference words: 5.00 5.00a 5.00c 7.00 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: September 13, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.