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
  In a new worksheet, enter the following values: A1: 1  B1: 5 A2: 2  B2: 6 A3: 3  B3: 7 A4: 4  B4: 8  Select the range A1:B4. From the Insert menu, choose Chart, and then choose As New Sheet. In the ChartWizard dialog box, choose the Finish button. In the new chart, select the second series (S2). 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.