XL98: Adding Series to XY (Scatter) Chart with Second X Axis

ID: Q192288


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


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. This article illustrates how to add a second series to an xy scatter chart that utilizes a second set of x values.


MORE INFORMATION

The following steps illustrate how to add a second series to an xy scatter chart using a different set of x values.

  1. Enter 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. In the list of chart types, click XY (Scatter). Click one of the line charts under Chart Sub-type. Click Next.


  4. Click the Series tab. Then, click Add. In the X Values box, type C1:C5; in the Y Values box, type D1:D5. Then, click Finish.


  5. In the chart, double-click the second series to display the Format Data Series dialog box. Click the Axis tab. Click Secondary Axis and click OK.


Additional query words: XL98

Keywords : kbdta kbchart
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.