Microsoft KB Archive/63384

Excel: Plotting Side-by-Side-Columns with Main and Overlay PSS ID Number: Q63384 Article last modified on 03-05-1992 PSS database name: M_eXceL

1.50 2.20

MACINTOSH

Summary:

In Microsoft Excel, if a column overlay chart is created over a column main chart, the overlay chart columns will overwrite the main chart columns.

The following is a procedure for creating a column chart for both an overlay and a main chart so that the columns do not overwrite each other:

  Insert blank series between the main and overlay chart data. The number of blank series should be two times the amount of overlay series. For example, if you have two series in the main chart, and three in the overlay chart, insert six blank series.   Highlight all the series, and from the Edit menu, choose Copy.   Open a new chart.   From the Edit menu, choose Paste Special.   Under Values In, select Rows or Columns, depending on how the data is arranged. Note: If labels are listed for each series, select Categories In First Row (or Column), depending on the data arrangement.   Click OK.   From the Chart menu, choose Add Overlay.   From the Format menu, choose Overlay. </li>  Change the chart type to Column and click OK. </li>  From the Chart menu, choose Axes and select Value Axis for the overlay chart. Click OK. </li></ol>

Copyright Microsoft Corporation 1992.