Microsoft KB Archive/93862

= Columns Half Width or Invisible in Column Chart Overlay =

Article ID: 93862

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 4.0a
 * Microsoft Excel 3.0 Standard Edition
 * Microsoft Excel 2.10d
 * Microsoft Excel 2.1 Standard Edition
 * Microsoft Excel 2.01
 * Microsoft Excel 2.0 Standard Edition
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q93862



SYMPTOMS
In Microsoft Excel, if you use a column chart overlay with a line chart, the first and last columns in the column chart overlay may be displayed at half the width of the other columns or they may not be visible at all.



WORKAROUND
To display the chart so that the columns are all displayed and are all the same width, use the appropriate method for your situation.

Method 1: If you are using Microsoft Excel version 5.0 or later, follow these steps:


 * 1) Select the chart and click AutoFormat on the Format menu.
 * 2) Under Galleries, click Combination, and click the first option in the Formats box.

Method 2: If you are using Microsoft Excel version 4.0a or earlier, follow these steps:

Use the following steps to use the Combination Chart 3 in the Combination dialog box (from the Gallery menu, choose Combination), and remove the y-axis value overlay.


 * 1) From the Gallery Menu, choose Combination.
 * 2) In the Chart Gallery dialog box, select option 3.
 * 3) Click OK.
 * 4) From the Format menu, choose Overlay.
 * 5) In the Format Chart dialog box, select Column from the Overlay Chart Type list.
 * 6) Click OK.
 * 7) Onthe Chart menu, click Axes.V
 * 8) In the Axes dialog box, clear the Value (Y) Axis option under Overlay.
 * 9) Click OK.

Additional query words: over lay 3D Excel

Keywords: KB93862

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.