To draw a line graph in Excel, select your data, go to Insert > Insert Line or Area Chart, and choose Line or Line with Markers.
A line graph turns rows of numbers into a trend you can see at a glance. Whether you’re tracking monthly sales or daily temperatures, Excel gives you a clean visual in three clicks. The method below covers the standard workflow, plus the tweaks that make your chart ready to share.
Creating a Line Graph in Excel: The Standard Method
Start by arranging your data with clear column headers and one column for the horizontal labels (dates, months, categories) and another for the values. Select every cell that belongs in the chart — including the headers.
- With the range highlighted, open the Insert tab on the ribbon.
- In the Charts group, click Insert Line or Area Chart.
- From the dropdown, select Line or Line with Markers. Markers help when the printed version might hide thin lines.
Excel places the chart on the sheet immediately. If you see a blank chart, right‑click the chart area and choose Select Data to add the series name, series values, and horizontal axis labels individually.
Should You Use a Line Chart or a Scatter Chart?
Line charts treat the horizontal axis as evenly spaced categories. Scatter charts treat both axes as true numeric values. Microsoft’s official guidance recommends a line chart when you have dates, quarters, or text labels, and a scatter chart when the x‑axis contains measurements like time intervals or weights that aren’t equally spaced.Microsoft’s line‑vs‑scatter guidance explains this distinction clearly.
| Feature | Line Chart | Scatter Chart |
|---|---|---|
| X‑axis purpose | Shows categories or time periods | Shows numeric measurements |
| Data spacing | Assumes equal intervals | Plots exact x‑values |
| Best example | Monthly revenue over a year | Height vs. weight |
| Trendline ready | Yes | Yes |
| Connect data points | Always connected in order | Connected only if sorted by x |
| When to use | Ordinal categories or dates | Irregular numeric intervals |
| When to avoid | Unevenly spaced measurements | Categories that aren’t numeric |
How to Customize Your Line Graph
Once the chart appears, you can refine every part of it in a few clicks.
- Axis titles – Click the + button beside the chart, check Axis Titles, then type directly into the text boxes.
- Chart title – Double‑click the default title and replace it with your own.
- Trendline – Click the chart, go to Chart Design > Add Chart Element > Trendline, and choose Linear, Exponential, or another option.
- Colors and style – Use the Chart Styles paintbrush icon to cycle through built‑in palettes.
For a quick axis label revision, right‑click the axis and select Format Axis to change intervals, number format, or display units.
Common Line Graph Mistakes and How to Fix Them
Even experienced users hit a few snags. The table below covers the most frequent issues and their fixes.
| Mistake | Symptom | Fix |
|---|---|---|
| Selecting blank rows or columns | Chart shows empty series or unwanted labels | Re‑select only the data cells you need |
| Data not sorted by x‑axis | Line zigzags back and forth | Sort your data in ascending order before inserting |
| Wrong chart type for numeric X | Categories appear out of order | Switch to a scatter chart (right‑click chart > Change Chart Type) |
| Missing axis labels | Horizontal axis shows 1,2,3… | Edit the horizontal axis in Select Data > Horizontal (Category) Axis Labels |
| Too many series on one chart | Chart looks cluttered | Remove redundant series via Select Data > Remove |
| Trendline doesn’t appear | Trendline option grayed out | Make sure the chart is a line (not a stacked line) and that you’ve selected a valid series |
| Line is too thin to see | Line nearly invisible on screen or in print | Right‑click the series, choose Format Data Series, and increase the line width |
The Essential Line Graph Workflow
- Format your data with column headers and one column for the category axis.
- Select the entire data range.
- Click Insert > Insert Line or Area Chart > Line.
- Add axis titles and a chart title using the + button.
- Add a trendline if you need to show direction.
- Adjust colors and line thickness for clarity and print.
This sequence handles almost every line‑graph task in Excel. For irregular numeric data, switch to a scatter chart instead.
References & Sources
- Microsoft Support. “Present your data in a scatter chart or a line chart.” Official guidance on choosing the right chart type and creating line graphs.