How to Make a XY Graph on Excel

Create XY Graph In Excel 2003
1. Open Microsoft Excel 2003.
2. Place your data such that all the X-values are in the same row or column. Place your other set of data in an adjacent row or column. For example, if you have six X-values and six Y-values, place all the X-values in column A and all the Y-values in column B.
3. Select the range of values to be included in the XY chart. To select the range of the six XY-value example, click the first cell included, which is A1, then drag your mouse to the last cell to be included, which is B6.
4. Go to the 'Insert' menu, and click 'Chart.'
5. Select 'XY (Scatter)' under the 'Chart Type' box. Choose the chart sub-type you want to use under the 'Chart sub-type' box.
6. Click 'Next' to show you the data range and a sample view of the chart.
7. Click 'Next' again to go to the 'Chart Options.' Enter the information for 'Chart Title,' 'Value (X) axis,' and 'Value (Y) axis.' These are text information you can use to make your chart descriptive.
8. Click 'Next' to go to the 'Chart Location' box. You can either place the chart as a separate worksheet or as an object in the same worksheet as your data points.
9. Click 'Finish' to display your XY chart.
Create XY Graph In Excel 2007 or 2010
10. Open Microsoft Excel.
11. Place your data such that all the X-values are in the same row or column. Place your other set of data in an adjacent row or column. For example, if you have six X-values and six Y-values, place all the X-values in column A and all the Y-values in column B.
12. Select the range of values to be included in the XY chart. To select the range of the six XY-value example, click the first cell included, which is A1. Drag your mouse to the last cell to be included, which is B6.
13. Go to the 'Insert' tab and click 'Scatter' in the 'Charts' group menu.
14. Click the 'Chart Area' of the XY chart. This shows the 'Chart Tools,' 'Design,' 'Layout,' and 'Format' tabs specific to the XY chart.
15. Click the chart style you want to use under the 'Design' tab.
16. Click 'Chart Title,' and type the title you want for the chart.
17. Click 'Axis Titles' on the 'Layout' tab. Click the 'Primary Horizontal Axis Title' to place a title in the horizontal axis. Click the 'Primary Vertical Axis Title' to place a title in the vertical axis.
18. Press 'Enter' to show the chart.