Microsoft Knowledge Base

Combination Chart Plots Incorrectly with XY (Scatter) & Column
Last reviewed: March 27, 1997
Article ID: Q147188
5.00 5.00c 7.00 | 5.00 5.00a 
WINDOWS         | MACINTOSH
kbusage

The information in this article applies to:

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

SYMPTOMS

When you create a combination chart using an xy (scatter) series and a column series, the bars for the column series will plot to the left side of the chart instead of plotting evenly across the chart as expected.

CAUSE

This behavior occurs because of the way the two chart types use the labels along the x axis. Xy (scatter) charts actually use the labels along the x axis to which to plot the data, whereas a column chart just sees them as labels.

WORKAROUND

In order to plot the column series correctly you must show the secondary x axis on your chart. To add a secondary x axis, follow these steps:

  1. Double-click the chart to activate it.

  2. On the Insert Menu, click Axes.

  3. Under Secondary Axis, click to select Category (X) Axis.

  4. Click OK.

KBCategory: kbusage
KBSubcategory:
Additional reference words: 7.00
Keywords : kbusage
Version : 5.00 5.00c 7.00 | 5.00 5.00a
Platform : MACINTOSH WINDOWS

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: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.