Microsoft Knowledge Base
XL: Secondary Value Axis Does Not Display Plotted Values
Last reviewed: September 13, 1996
Article ID: Q108726
The information in this article applies to:
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for Windows 95, version 7.0
- Microsoft Excel for the Macintosh, version 5.0
SUMMARY
In a Microsoft Excel chart, if you change a series type to bar and then insert a secondary category (x) axis, the bar with the highest value may not be displayed in the chart.
MORE INFORMATION
Steps to Reproduce Behavior
On a new worksheet, enter the following data:
A1: 1 B1: 3 C1: 5 A2: 2 B2: 4 C2: 6
- Select cells A1 to C2.
- To create a Column chart, press the F11 key and choose Finish.
- Select the first column for the first series.
- From the Format menu, choose Chart Type.
- Choose Bar and then choose OK.
- From the Insert menu choose Axes.
- Select Secondary Axis Category (X) Axis and choose OK.
When the Secondary Category (X) Axis has been inserted, only two bars are displayed (although three bars are plotted). The bar with the largest value is not displayed. Depending on the data, this problem will not always occur.
To show that the series value is overlaid on the secondary x axis, choose Data Labels from the Insert menu.
WORKAROUND
Select the overlaid (top) y axis and increase the maximum value. This will allow the missing bar to be displayed. To scale the axis, follow these steps:
- Select the overlaid (top) y axis.
- From the Format menu, choose Selected Axis.
- Choose the Scale tab.
- Increase the value for the Maximum scale.
REFERENCES
"User s Guide," version 5.0, Chapter 16, pages 284-285
For more information about secondary axes, choose the Search button in Help and type:
secondary axes
KBCategory: kbusage Last reviewed: September 13, 1996 |