How can I do line charts in Excel?
- Select x-data column (Ctrl/Command + Shift + End to fast-select)
- Select y-data column (Ctrl/Command to select one cell in addition to the x-column, Ctrl/Command + Shift + End to fast-select)
- Insert > Chart > Scatter > Smooth Lined Scatter
First, watch Mr. Pauller's video on how to use Excel for linear regression.
In a line chart, the horizontal axis is a "category" axis, not a "value" axis. The points are evenly distributed along the axis.
Use a line chart if your horizontal axis uses
- Text labels or
- A small set of numerical labels representing evenly spaced intervals
Assume that you want to plot the population of bears over a number of years.
Enter your data into Columns A and B of the Excel spreadsheet.
Assume that your data are:
If you have numeric labels, as here, leave cell A1 empty. This ensures that Excel recognizes the numbers in column A as categories
Highlight the data. Click on "Insert. Charts"
Click the small triangle under Line. Select Line with Markers (the first graph in the second row).
You should get a graph that looks like this.
This is your basic line chart.
Now you can experiment with other options to improve its appearance. Here's one possibility.