Excel Line Charts: The Complete Guide
Line charts are the go-to for trends and time series. This guide covers every line variant (with markers, area, stacked area, smoothed), dual-axis line charts, and how to add trendlines, forecasts, and annotations.
When to use line charts
Line charts are best for:
- Time series — daily, monthly, or quarterly values plotted across time
- Trends — direction and shape of change matter more than exact values
- Comparison over time — multiple metrics tracked against the same time axis
- Continuous data — when the x-axis represents a continuous variable
Don't use line charts for categorical comparison (use bars) or for data with fewer than ~5 points (use column charts — a line with 3 points doesn't communicate trend).
The five line chart variants
1. Plain line
Straight-line segments connecting points. The default. Best for clean trend visualization.
2. Line with markers
Same as plain line but each data point has a visible marker (circle, square, triangle). Best when you have fewer data points (up to ~20) and want the specific values to be identifiable.
3. Stacked line
Values stacked on top of each other. Rarely useful — stacked areas communicate the same thing better because the eye can compare heights of filled shapes more easily than differences between lines.
4. Area chart
Line chart with the area beneath filled in. Emphasizes cumulative volume rather than specific values.
5. Stacked area / 100% stacked area
Multiple filled areas stacked. Shows total (or 100%) and composition changing over time. Great for revenue-by-segment or category-share evolution.
How to insert a line chart
Select your data
Time axis in the first column, series in subsequent columns, headers in row 1.
Insert tab → Line icon
Dropdown shows plain line, line with markers, stacked line, area variants.
Pick the variant
For most trend visualizations, plain line or line with markers is right.
Format for clarity
Delete gridlines you don't need, label lines directly, use a takeaway title.
Advanced line chart techniques
Add a trendline
Right-click any data series → Add Trendline. Options:
- Linear — straight-line best fit
- Exponential — for compound growth
- Logarithmic — for growth that slows over time
- Polynomial — for curved patterns
- Moving average — smoothed line showing longer-term trend
Tick "Display equation" and "Display R-squared" to show the underlying math.
Forecast future values
In Trendline options, set "Forecast Forward" to the number of periods. Excel extends the trendline into the future based on the fit.
Dual-axis line charts
Two lines on wildly different scales? Right-click the smaller-scale series → Change Series Chart Type → check "Secondary Axis." Excel adds a second Y-axis for that series.
Highlight a specific period
To shade a specific period (recession, campaign window):
- Add a helper column with your line's max value only during that period, blank otherwise
- Add that column as a new series to the chart
- Change its chart type to a column (or area) with high transparency
Result: a translucent vertical shade highlighting the period behind your lines.
Sparklines for compact trends
When space is tight (dashboard, summary table), use sparklines. Insert → Sparklines → Line. Each sparkline lives in one cell and shows a mini-trend for that row's data.
Formatting for presentation
Line weight and color
Default lines are thin and pale. Set line weight to 2.25pt for readable lines, 3pt for standout series, 1.5pt for context lines. Use one saturated color for your primary series and one gray for supporting/comparison series.
Label lines directly
Legends make readers work. On a chart with 2-4 lines, add a data label to the last point of each series (Right-click point → Add Data Label → Format to show series name). Delete the legend.
Handle missing data
Chart Design → Select Data → Hidden and Empty Cells. Options:
- Gaps — line breaks where data is missing
- Zero — treats blanks as 0 (usually wrong, creates false dips)
- Connect data points with line — bridges the gap
If your time axis is dates, use "Date axis" (Format Axis → Axis type → Date). Excel spaces points by actual time, so a 3-month gap looks 3× wider than a 1-month gap. On "Text axis," every point is equally spaced regardless of dates — often misleading.
Common line chart mistakes
More than 4-5 lines becomes spaghetti. Consider small multiples (one chart per series in a grid) or highlight one line while graying out the others.
A line chart with categories (Product A, B, C, D) on the x-axis implies order and trend where none exists. Use a bar chart.
Line charts have more latitude than bar charts for non-zero baselines — but only when the natural range is far from zero. Don't zoom in artificially to make small changes look dramatic.
Frequently asked questions
How do I add a trendline to a line chart?
Right-click any data series → Add Trendline. Choose linear, exponential, logarithmic, polynomial, or moving average based on your data's shape. Tick 'Display equation' and 'Display R-squared' to show the math.
How do I make a line chart with dual Y-axes?
Right-click the data series that should use the secondary axis → Change Series Chart Type → check 'Secondary Axis'. Excel adds a right-side Y-axis for that series with its own scale.
When should I use a line chart vs area chart?
Use line when specific values matter and you want cleanness. Use area when total magnitude matters more than individual values. Use stacked area when composition over time is the point.
How do I handle missing data in a line chart?
Chart Design → Select Data → Hidden and Empty Cells. Set to 'Gaps' (line breaks) if you want to show missing data honestly, or 'Connect data points with line' to bridge the gap. Avoid 'Zero' — it usually creates misleading dips.