Microsoft KB Archive/25652

{| = Excel: Plotting More Than One Y Series in an X-Y Chart =
 * width="100%"|

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.
 * }