Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102862

From BetaArchive Wiki

XL3/XL4: How to Create a 2-D chart with Two Identical Y- Axes

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
  • Microsoft Excel for OS/2 versions 3.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0


In Microsoft Excel, to display two y-axes on a 2-D chart, you use an Overlay on the chart. When you create an overlay, at least one series must be used in the overlay. To create an additional y-axis that is identical to the first y-axis without displaying an overlay series, include an empty series in your chart and format this empty series as as the overlay series.


To create a 2-D chart with two identical y-axes, do the following:

  1. Create your chart using any of the conventional methods.
  2. With the chart active, click Edit Series on the Format menu.
  3. With New Series selected, create an empty series by placing a reference to an empty cell in the X Labels and Y Values boxes. Click OK to define the new series.
  4. On the Chart menu, click Add Overlay.
  5. On the Format menu, click Overlay. Make sure that the first overlay series is the last series available (the empty one).
  6. On the Chart menu, click Axes. In the Overlay box, check (enable) the Value (Y) Axis check box. Click OK to accept the change.
  7. Select the new axis on the right side of the chart, and click Scale on the Format menu.
  8. Change the scale of the new axis to match the primary y-axis.
  9. Change the color of each series back to its original color.

NOTE: If your chart has a legend, when you create any new series, even an empty one, the legend will be changed.

For more information on how to reverse the change to your legend, query on the following words in the Microsoft Knowledge Base:

   series and symbol and legend and pattern 


"User's Guide 1," version 4.0, pages 428-431, 469
"User's Guide," version 3.0 for Windows, pages 422-424, 426, 441-444
"User's Guide," version 3.0 for Macintosh, pages 422-424, 426, 441-444

Additional query words: 4.00a graph duplicate multiple XL3 XL4

Keywords : xlchart
Version : WINDOWS:3.0,4.0,4.0a; OS/2:3.0; MACINTOSH:3.0,4.0
Issue type : kbinfo
Technology : kbvcSearch

Last Reviewed: July 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.