Creating a line chart in Excel takes about five minutes once you have your data in place
A line chart in Excel shows how something changes over time — sales by month, temperature by day, website visits by week. You start by selecting the data you want to chart, click the Insert menu, pick Line Chart, and Excel builds it for you. The chart appears on the same sheet as your data and you can move it, resize it, or change how it looks without touching the original numbers.
The reason to use a line chart instead of a table is that your eye can spot trends when ready. A column of numbers showing sales going up and down month by month takes effort to read. The same data as a line chart shows the pattern in one glance. If you need to show that pattern to someone else — in a report, a presentation, or an email — a chart does the work that words would take paragraphs to explain.
Key Takeaways
- Your data needs two columns: one for the time periods (months, dates, weeks) and one for the numbers you are measuring.
- Select both columns including the headers, then go to Insert and choose Line Chart from the Charts group.
- Excel places the chart on your sheet automatically, and you can drag it to a new location or resize it by pulling the corners.
- Right-click the chart to add a title, change the colors, or adjust the axis labels so someone reading it understands what they are looking at.
Setting up your data the way Excel expects it
Excel needs your information arranged in columns, not rows. Put your time periods in the left column — these might be month names (January, February, March), dates (1/1/2024, 1/2/2024), or week numbers. Put the numbers you are measuring in the column to the right — sales figures, temperature readings, visitor counts, whatever you are tracking.
Include a header row at the top. In the left column, type something like "Month" or "Date". In the right column, type what you are measuring — "Sales", "Temperature", "Website Visits". Headers help Excel understand what each column represents, and they appear on your finished chart as labels.
If you have more than one set of numbers to track, add another column. For example, you might have "January Sales", "February Sales" in one column and "January Expenses", "February Expenses" in another. Excel will draw a separate line for each one, so you can compare them side by side.
Selecting your data and inserting the chart
Click on the first cell of your data — the header cell in the top left. Hold down your mouse button and drag to the last cell that contains information. This selects a rectangle of data. If your data is in columns A and B from row 1 to row 13, you will select from A1 to B13. Release the mouse button when you reach the bottom right of your data.
Go to the Insert menu at the top of the screen. Look for a section labeled Charts. Click on the small arrow or dropdown next to "Line Chart" — not the word Line Chart itself, but the small arrow beside it. A menu appears showing different line chart styles. The first option, which shows points connected by lines, works for most situations. Click it.
Excel creates the chart and places it on your sheet, usually overlapping your data. The chart is selected (you will see small squares around its edges). You can now drag it to a new location by clicking and holding anywhere on the chart background and moving your mouse. Drag it to the right of your data or below it, somewhere it does not cover the numbers you need to see.
Resizing and moving your chart
To make the chart bigger or smaller, position your mouse over one of the small squares at the corners or edges of the chart. Your cursor will change to a double-headed arrow. Click and drag outward to make the chart larger, or inward to make it smaller. Dragging a corner square keeps the chart proportional. Dragging an edge square stretches it in one direction only.
If you want to move the chart to a different location on the sheet, click anywhere on the chart background (not on the lines or numbers) and drag the entire chart to where you want it. The chart stays selected while you move it, so you can position it precisely.
Adding a title and labels so the chart makes sense
Right-click anywhere on the chart. A menu appears with options like "Add Chart Title" or "Edit Data". Click "Add Chart Title". A text box appears at the top of the chart with placeholder text. Click on that text and type a title that explains what the chart shows — "Monthly Sales 2024" or "Daily Temperature This Week".
Right-click the chart again and look for "Axis Titles" or similar options. You can add a label to the left side (the vertical axis) to explain what the numbers mean — "Sales in Dollars" or "Temperature in Fahrenheit". You can add a label to the bottom (the horizontal axis) if it is not already clear — "Month" or "Date".
If the lines are hard to tell apart, right-click the chart and look for "Change Colors" or "Format Data Series". You can make one line thicker, change it to a different color, or add markers (small dots) at each data point so the line is easier to follow. These changes are optional — the chart works without them — but they make it easier for someone else to read.
Updating the chart when your data changes
If you add new data to your columns, the chart does not automatically include it. You need to tell Excel to use more data. Right-click the chart and select "Select Data" or "Edit Data". A dialog box opens showing which cells Excel is currently using. Change the range to include your new rows. For example, if you added data in row 14, change the range from B1:B13 to B1:B14. Click OK and the chart updates to show the new information.
If you change the numbers in your existing data — you realize January sales were actually higher, or you get a corrected temperature reading — the chart updates automatically. You do not need to do anything. Excel watches your data and redraws the lines whenever the numbers change.
Choosing between a line chart and other chart types
A line chart works best when you are showing change over time and you have many data points — at least five or six. If you only have two or three numbers to compare, a bar chart or column chart is often clearer. If you are showing how a total breaks down into parts — what percentage of your budget goes to rent, food, utilities — a pie chart is the right choice.
Line charts also work well when you are comparing two related things over the same time period. You might chart both sales and expenses on the same line chart to see whether they move together or apart. A bar chart could show this too, but a line chart makes the trend easier to see at a glance.
If your time periods are not evenly spaced — you have data for January, March, and June but not the months in between — a line chart can be misleading because it draws a line between points that are not actually adjacent. In that case, a scatter plot or a bar chart is more honest about the gaps in your data.
Frequently Asked Questions
Can I create a line chart from data in different sheets?
Yes, but it is easier to copy the data into one sheet first. Select the data you want to chart, copy it, go to a new sheet, paste it, and then create the chart. If you want to chart data from multiple sheets without copying, you can edit the chart's data range manually, but this is more complicated and the simpler approach usually saves time.
What if my data has blank cells or missing months?
Excel will skip blank cells and draw the line from the point before the blank to the point after it. If you have January, then a blank cell, then March, the line connects January directly to March. If you want to show that there is a gap, add a row for the missing month and leave the number column blank, or use a scatter plot instead of a line chart.
How do I delete a chart I no longer need?
Click on the chart to select it, then press the Delete key. The chart disappears but your data stays in place. If you delete it by accident, press Ctrl+Z (or Cmd+Z on a Mac) to undo and bring it back.
Can I print just the chart without the data?
Yes. Click on the chart to select it, then go to File and Print. Excel will print only the selected chart on its own page. If you do not select the chart first, it prints the entire sheet including your data.
What does it mean when my line chart shows a straight horizontal line?
It means all your numbers are the same — there is no change over time. Check your data to make sure you entered the numbers correctly. If the numbers really are all identical, a line chart is not the right choice; a single number or a table would communicate this more clearly.