Excel: Columns Half Width or Invisible in Column Chart Overlay

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

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.

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

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 30, 1999