Microsoft KB Archive/79972

= XY (Scatter) Chart Not Correct with First Column Labeled =

Article ID: 79972

Article Last Modified on 7/30/2001



This article was previously published under Q79972



SUMMARY
Microsoft Works for Windows does not create a true XY (scatter) chart if the first column of data on the spreadsheet is labeled. When the first column is labeled, the data is incorrectly used as the first data series. A true XY chart needs an X and Y coordinate for each point on the chart. By removing the first column label, the first column is used for the category (X) axis data and the second column is used for the first value (Y) axis data. This creates a true scatter chart by plotting the intersection of the X and Y values.



MORE INFORMATION
An example of spreadsheet columns before creating an XY chart: Correct             Incorrect ---             -


 * | Y Data |   | X Data | Y Data |
 * 1  |   12   |    |    1   |   12   |
 * 3  |    4   |    |    3   |   4    |
 * 5  |    1   |    |    5   |   1    |
 * 3  |    4   |    |    3   |   4    |
 * 5  |    1   |    |    5   |   1    |
 * 5  |    1   |    |    5   |   1    |

Steps to Creating an XY Chart
 Highlight the range of cells containing the X series data, the Y series label, and the Y series data. On the tool bar, choose the Chart button.

-or-

From the Charts menu, choose Create New Chart. On the tool bar, choose the Scatter Chart button.

-or-

Front the Gallery menu, choose XY Scatter. Choose the style you want and choose OK.

To check if the XY chart has been created correctly, choose Series from the Edit menu. A correct XY chart will show the range for X axis data in the category (X) series and the range for Y axis data in the 1st series.

