ARTICLE / 5 MIN READ
How to Make a Line Chart in Excel (Step by Step)
FEBRUARY 19, 2026
If you want to show how something changed over time — revenue by month, users by week, temperature by day — a line chart is almost always the right choice.
Here’s how to build one in Excel from scratch, plus a few tweaks that make a big difference in how it looks.
When to Use a Line Chart
Line charts are built for time series data — data where the x-axis is a sequence of dates, times, or ordered periods.
Use a line chart when:
- You’re showing a trend over days, weeks, months, or years
- You want to compare how two or more things changed over the same time period
- You want to highlight whether something is going up, down, or holding steady
Don’t use a line chart for unordered categories (like product names or regions). A line implies a connection between points — and if the categories have no natural sequence, that connection is misleading. Use a column or bar chart instead.
Step 1 — Structure Your Data
For a line chart, your data should look like this:
| Month | Sales |
|---|---|
| Jan | 10200 |
| Feb | 11800 |
| Mar | 13400 |
The left column is your time axis (months, weeks, dates). The right column(s) are the values you’re plotting. If you want multiple lines, just add more columns — one per line.
Step 2 — Select Your Data and Insert the Chart
Click the first cell of your data, drag to select everything including headers, then go to:
Insert → Charts → Line (look for the line chart icon in the Charts group)
Click the first option — Line with Markers is usually a good starting point because it shows both the line and the individual data points.
Excel inserts the chart immediately.
Step 3 — Fix the Axes If Needed
Sometimes Excel plots your data the wrong way — your months end up as a data series instead of the x-axis. If this happens:
Right-click the chart → Select Data → click Switch Row/Column
If your dates are showing as numbers instead of month names, click on the horizontal axis, right-click → Format Axis → change the number format to your preferred date style.
Step 4 — Add a Meaningful Title
Click on the “Chart Title” placeholder at the top and replace it with something descriptive.
Good: Monthly Sales Jan–Mar 2026 Bad: Sales or Chart 1
Your title should tell someone exactly what they’re looking at without needing to read the axes.
Step 5 — The Formatting Tweaks That Actually Matter
Smooth the line. Right-click on the line → Format Data Series → check Smoothed line. It makes jagged data look much cleaner.
Remove the markers if you have lots of data points. Markers (dots on each point) look great with 6–12 points. With 50+ points, they clutter the chart. Right-click the line → Format Data Series → Marker → None.
Increase the line thickness. A thin line is hard to read. Right-click the line → Format Data Series → Line → Width — bump it up to 2–2.5pt.
Turn off gridlines if the chart feels busy: click on a gridline and press Delete.
Adding a Second Line for Comparison
Want to compare two trends on the same chart? Just add a second column of data next to your first one before creating the chart.
| Month | Revenue | Target |
|---|---|---|
| Jan | 10200 | 12000 |
| Feb | 11800 | 12000 |
| Mar | 13400 | 12000 |
Select all three columns and insert the chart the same way. Excel plots one line per data column automatically.
Make the “Target” line a dashed style (Format Data Series → Line → Dash type) to visually distinguish it from the actual data.
Saving and Sharing Your Chart
To export just the chart as an image, right-click the chart → Save as Picture → choose PNG or JPEG.
To use it in a Word doc or PowerPoint, just copy it (Ctrl+C) and paste — it embeds cleanly.
Line charts are one of the most powerful tools in Excel for communication. A well-made line chart can tell a story in seconds that a data table would take minutes to read.