XL97: Chart Series Doesn't Use Removed Secondary Axis Scale

ID: Q161664

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you plot a chart series along a secondary series axis that uses a different scale than the primary axis, and you remove the secondary axis, the series does not use the scale of the axis that you remove. Instead, Microsoft Excel plots the series using the scale of the primary axis.

WORKAROUND

To plot a chart series or group with a different scale from the scale that the primary axis uses without displaying a secondary axis, format the secondary axis so that it does not appear on the chart. To do this, follow these steps:

1. Select the secondary axis (the axis you do not want appear). On the

   Format menu, click Selected Axis.

2. Click the Patterns tab. Under Axis, click None, and under Tick-Mark
   Labels, click None, and then click OK.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

If you plot a chart series or group on a secondary axis, the series or group uses only the scale of the secondary axis if it is available.

NOTE: This behavior is different from versions of Microsoft Excel that are earlier than version 5.0. In earlier versions, if you plot a chart overlay on an overlay axis and format the axis with a different scale from the main axis scale, the chart overlay uses the overlay axis scale. This is true even if you remove the overlay axis.

REFERENCES

For more information about changing the value axis scale, click the Index tab in Microsoft Excel Help, type the following text

   chart

and then double-click the selected text to go to the "Display or hide axes in a chart" topic.

Additional query words: XL97 secondary axes chart missing truncated

Keywords          : kbualink97 kbchart
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: October 31, 1998