Microsoft Excel 2007 is a comprehensive spreadsheet program that not only stores data, but provides charts and graphs to represent the data graphically. To create an X-Y line graph, you should enter the data you want to graph and format a scatter (X-Y) plot. A scatter plot is similar to a line graph, except it is used specifically to compare pairs of values (X versus Y). You may then choose to create a smooth line to connect the data points.

- Skill level:
- Easy

### Other People Are Reading

### Things you need

- Microsoft Excel 2007
- X-Y data

Show More

## Instructions

- 1
Open a blank worksheet in Microsoft Excel 2007.

- 2
In the first cell, enter “X.” Press “Tab,” and enter “Y” in the next cell over. These will be the column headings for your X and Y data.

- 3
Enter a series of X data points in the column under “X.” It’s a good idea to simply enter regular intervals of X to make up the horizontal axis. For instance, enter all the values ranging from “-5” up to “5” to display the line across a negative and positive axis.

- 4
Calculate the Y value that corresponds to each X value. The equation format for a line graph is Y = MX + B, where M is the slope of the line and B is the Y-intercept value. If you have a linear equation for the line, plug the X values you’ve entered into the equation to calculate the Y values. Enter each value in the Y column.

- 5
Highlight the cells you want to graph on a chart.

- 6
Click the “Insert” tab. In the “Charts” group, select the “Scatter” icon.

- 7
Select “Scatter with Smooth Lines and Markers.” This will display X versus Y in a line graph that connects the data markers. The chart will display on your worksheet.

- 8
Click the “Design” tab, which appears under “Chart Tools” when you select the chart. If you want to change the format of the chart, make a selection in “Chart Layouts” and a line style under “Chart Styles.” To format individual elements of the chart, click the “Format” tab and select the element you want to change, such as “Chart Title” or “Axes.”

- 9
Click the “Microsoft Office Button,” and select “Save” to save the data and graph you’ve made.