**Create a line chart**

- Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart.
- Select the data that you want to plot in the line chart.
- Click the Insert tab, and then click Insert Line or Area Chart.
- Click Line with Markers.

## How do I use Excel to draw a graph?

Suggested clip 101 seconds

How to Plot a Graph in Excel (Video Tutorial) – YouTube

YouTube

Start of suggested clip

End of suggested clip

## How do you make an XY graph in Excel?

Suggested clip 114 seconds

Creating an XY Scatter Plot in Excel – YouTube

YouTube

Start of suggested clip

End of suggested clip

## How do you create a graph?

Suggested clip 83 seconds

How to Create a Graph in Excel – YouTube

YouTube

Start of suggested clip

End of suggested clip

## How do I turn Excel data into a graph?

**How to Make a Graph in Excel**

- Enter your data into Excel.
- Choose one of nine graph and chart options to make.
- Highlight your data and ‘Insert’ your desired graph.
- Switch the data on each axis, if necessary.
- Adjust your data’s layout and colors.
- Change the size of your chart’s legend and axis labels.

## How do I make a line graph?

**How to Create a Line Graph**

- Create a table. Draw the x- and y-axes on the page.
- Label each axis. If time is one of the factors, it should go along the horizontal (x) axis.
- Add data. Data for a line graph is usually contained in a two-column table corresponding to the x- and y-axes.
- Create a key.

## How do I edit a scatter graph in Excel?

Select the data you want to plot in the chart. Click the Insert tab, and then click X Y Scatter, and under Scatter, pick a chart. With the chart selected, click the Chart Design tab to do any of the following: Click Add Chart Element to modify details like the title, labels, and the legend.

## How do you draw an intercept line in Excel?

- Click the cell in your spreadsheet in which you would like Excel to display the y-intercept of your line.
- Type “=INTERCEPT(” without quotes in the formula bar above the spreadsheet.
- Click the first cell containing the y values of the line that you need the intercept for.
- Type a comma in the formula field.

## How do you draw a scatter graph?

**Scatter Diagram Procedure**

- Collect pairs of data where a relationship is suspected.
- Draw a graph with the independent variable on the horizontal axis and the dependent variable on the vertical axis.
- Look at the pattern of points to see if a relationship is obvious.
- Divide points on the graph into four quadrants.