HOW TO: Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000

This article was previously published under Q214292
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 98 version of this article, see 192288.
For a Microsoft Excel 97 and earlier version of this article, see 115073.


When you add a second series to an XY (scatter) chart, the new values areadded with respect to the same x-axis values as the first series. This step-by-step article explains how to add a second series to an XY (scatter) chart that uses a second set of x values.

back to the top

Add Second Series to Chart

To add a second series to an XY (scatter) chart with a different set of xvalues, follow these steps:
  1. Type the following data into a worksheet:
       A1: 1     B1: 5     C1: -1     D1: -5   A2: 2     B2: 6     C2: -2     D2: -6   A3: 3     B3: 4     C3: -3     D3: -8   A4: 4     B4: 2     C4: -4     D4: -5   A5: 5     B5: 5     C5: -5     D5: -1					
  2. Select the range A1:B5. On the standard toolbar, click the Chart Wizard tool.
  3. On the list of chart types, click XY (Scatter). Click one of the line charts under Chart sub-type, and then click Next.
  4. Click the Series tab, and then click Add. In the X Values box, type =Sheet1!$C$1:$C$5; in the Y Values box, type =Sheet1!$D$1:$D$5. Click Finish.
  5. On the chart, click a plotted item, and then click Format Data Series. Click the Axis tab, click Secondary axis, and then click OK.
back to the top
For more information about how to add a new series, click Microsoft Excel Help on the Help menu, type add series lines to charts in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

back to the top
non-contiguous contiguous axes overlay XL2000

Article ID: 214292 - Last Review: 12/05/2015 12:33:04 - Revision: 4.1

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kbchart kbhowto kbhowtomaster KB214292