Microsoft KB Archive/124575

{|
 * width="100%"|

XL: How to Insert Multiple Series in an XY (Scatter) Chart

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
When you add a second series to an xy (scatter) chart, the new values will be added with respect to the same x axis values as the first series. In order to add a second series to the chart using unrelated x-axis values, the additional series x values range must be added after you plot the chart.

MORE INFORMATION
To add a second series to an xy (scatter) chart that uses a different set of x values, use either of the methods below.

NOTE: Both of the following methods use the sample data below. To use this data, enter it in a worksheet.

Sample Data
  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 Method 1:

 Select the range A1:B5, and in the ChartWizard, select the following options:  In step 1 of 4, choose Next. In Step 2 of 4, choose XY (Scatter), and then choose Next. In Step 3 of 4, choose type 2, and then choose Next. In step 4 of 4, choose Data Series In Columns: use first 1 column(s) for X Data, first 0 row(s) for Legend Text. Choose the Finish button.  Double-click the chart to open it and size the chart to full screen. From the Chart menu, choose Edit Series, and select New Series.</li> In the X Values field, replace the cell references with the range for the new X Value series. In the Y Values field, add the Y Values cell references for the new Y Series, and click OK.</li> Repeat steps c and d for each series you want to add.</li></ol>

Method 2:

<ol style="list-style-type: lower-alpha;"> Select cells A1:B5,D1:D5 and create a chart using the ChartWizard. (Note the range is a nonadjacent selection that you can select by pressing the CTRL key and selecting the different cell ranges.)</li> In the ChartWizard, do the following:  In Step 1 of 4, choose Next.</li> In Step 2 of 4, choose XY(Scatter), and then choose Next.</li> In Step 3 of 4, choose type 2, and then choose Next.</li> In Step 4 of 4, choose Data Series in Columns</li> Use first 1 column(s) for X Data-Use first 0 row(s) for Legend Text</li> Choose the Finish button.</li></ul> </li> Double-click the chart to open then select the line in the chart for the second series (the name box indicator should indicate S2). From the Chart menu, choose Edit Series, and select Data Series.</li> Replace the X Values reference with the new x-axis reference for the second series, and choose OK. (In this example, the correct reference would be C1:C5.)</li></ol>