Excel: Plotting More Than One Y Series in an X-Y Chart

 Last reviewed: November 2, 1994
Article ID: Q25652

SUMMARY

In Microsoft Excel, to create an X-Y plot with more than one set of Y values, do the following:

  1. Arrange the information on the worksheet so that the single X-values column is to the left of any number of series of Y-values in different columns.

  2. Place series names above each of the Y-values columns, but leave the cell above the one X-values column blank.

  3. Select the first (blank) cell of the X-values column through the last cell in the last column of Y-values.

  4. From the File menu, choose New and select Chart.

  5. From the Gallery menu, choose Scatter, select a type of scatter chart, and click OK.

KBCategory: kbother
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.