Excel Solid Line Chart: Create and Format One

To make a solid line chart in Excel for Microsoft 365 on Windows, select your data and choose Insert > Insert Line or Area Chart > 2-D Line. To change an existing series to a solid stroke, right-click that line, choose Format Data Series, then select Fill & Line > Line > Solid line. A line chart is useful for showing how one or more values change across an ordered sequence, such as months or dates.

What a solid line chart means in Excel

A solid line chart connects each data point in a series with an unbroken line. The horizontal axis usually represents categories, such as months, product names, or stages, while the vertical axis represents numeric values. In a chart with several series, Excel gives each series its own line so readers can compare their movement.

Solid describes the line style, not a separate chart type. Excel can draw a line as solid, dashed, dotted, or another available dash pattern. A standard 2-D Line chart commonly starts with solid lines, but an applied chart style, theme, or manual formatting may change how a series looks. You can explicitly set its style when consistency matters.

A line chart is not the same thing as a chart that merely has a visible line. A series can have markers at each point, no markers, or a line set to No line. A line chart may also display gaps where data is missing. Those are separate settings from whether the connecting stroke is solid.

Create a line chart from worksheet data

Arrange the data with category labels in the first column or row and numeric values beside them. For example, put Month in A1, Orders in B1, and January through April in A2:A5, with the matching order counts in B2:B5. Select the entire range, including its headings, before inserting a chart.

Select the cells containing the labels, headings, and values.
Open Insert > Insert Line or Area Chart.
Under 2-D Line, choose Line. Choose Line with Markers if you want a visible symbol at each data point.
Use the Chart Design tab to add or adjust chart elements, such as a title, axis titles, legend, or gridlines.

Excel uses the selected headings to name series and the label cells to populate the category axis. If the chart plots months as separate series instead of treating them as categories, select the chart and choose Chart Design > Switch Row/Column. This is helpful when the table’s rows and columns are oriented differently from the comparison you intend to show.

On Excel for Mac, the Insert tab also provides line chart choices, and selecting a series opens a formatting pane. Ribbon wording and pane layout can vary slightly by release. Excel for the web has chart insertion and formatting options too, though some advanced formatting controls may be more limited than in the desktop app.

Set the series line to solid

To explicitly format a line, select the chart and click the series you want to change. A first click generally selects the series; clicking a point again can select only that individual point. Right-click the selected series and choose Format Data Series to open the formatting pane. In the pane, choose Fill & Line, expand Line, and select Solid line.

Then set the color, width, transparency, and dash type as needed. A width around 1.5 to 2.25 points is often easier to see than a hairline in a report, but the right choice depends on chart size and display. If you need several series, select and format each one separately. Choosing a solid stroke does not automatically give every series the same color or width.

If you do not see a line after choosing Solid line, check that Line is not set to No line and that the series has at least two plottable points. You can also use the formatting pane to change marker settings separately. To distinguish series without relying only on color, combine different marker shapes or line styles where appropriate, while keeping the main series easy to identify.

For quick formatting, the Chart Format tab can expose options for the selected chart element, including shape outline controls. The Format Data Series pane is the more direct place to set a series’ line properties and confirm the dash type. Avoid applying a chart style blindly if it changes the contrast or line pattern you need.

Prepare categories and values carefully

The chart can only communicate clearly if its source range is organized and meaningful. Keep one header row, use a consistent unit for each series, and sort categories into the intended order. Dates are often best placed in chronological order. If labels are text such as Q1, Q2, Q3, and Q4, Excel may treat them as categories in the sequence supplied, so sort them deliberately rather than assuming the chart will rearrange them.

For example, a monthly sales chart might have Date in column A, Actual sales in column B, and Forecast in column C. Selecting all three columns produces two series that can be compared across the same date categories. Give each series a clear heading, and include the unit in the axis title or chart title if the values could be mistaken for another measure.

Check whether a blank cell means no observation or a true zero. A zero is a measured value at the baseline; a blank represents missing or absent data. Excel charts can display empty cells as gaps, zeros, or connected data points depending on the chart’s empty-cell setting and version. Select the chart and use Chart Design > Select Data, then look for Hidden and Empty Cells to review the available display choices. Connecting across missing data can imply a continuous trend that was never measured, so use that option only when it accurately represents the data.

When a line chart is the right choice

A line chart is a strong choice when the horizontal order matters and the categories are evenly spaced in the chart. It makes a trend easy to scan: readers can spot rises, falls, turning points, and periods that are relatively stable. Typical examples include monthly revenue, daily temperatures, and a sequence of test results.

Use an XY (Scatter) chart instead when the horizontal values are numeric measurements whose spacing carries meaning. A Line chart treats its horizontal axis as categories, so dates or numbers can appear at equal category intervals even if the elapsed time between them is unequal. A scatter chart positions points according to their numeric x-values. If measurements were recorded on January 1, January 2, and January 20, a scatter chart can show the longer gap before the final observation more faithfully.

A line chart is also not automatically a good choice for unrelated categories. Connecting values for departments, cities, or product types may suggest a continuous progression where none exists. A bar or column chart is often clearer for comparing separate groups. The key question is whether joining the observations helps explain an ordered progression, rather than simply whether Excel offers a line option.

Make the chart easier to read

A solid line can become difficult to interpret when too many series overlap. Keep the legend labels specific, use a restrained palette, and consider highlighting only the series that matters most. If the chart has many closely spaced observations, markers can clutter the display; remove them or reserve markers for a small number of important points. Conversely, markers help readers identify exact observations in a short series.

Use a descriptive title and axis labels when the measure or unit is not obvious. Gridlines can help estimate values, but too many heavy gridlines compete with the data. The vertical axis scale also affects the visual impression: a truncated baseline can make modest changes look dramatic. A line chart does not always need to start at zero, especially when the purpose is to inspect small fluctuations, but the scale should be visible and chosen honestly so readers understand the magnitude.

Consider where the chart will be read. A thin pale line may be visible on a bright monitor but disappear in a printed report or when copied into a presentation. Check contrast against the chart background, avoid using color as the sole way to distinguish lines, and preview the chart at its final size. If it will be printed in grayscale, use distinguishable markers or line patterns and test the printed result.

Common problems and fixes

The chart looks like points without a connecting line: Select the series and inspect Format Data Series > Fill & Line > Line. Set Solid line rather than No line. Confirm that the chart type is Line, not a markers-only variant.
The x-axis labels or series are reversed: Use Chart Design > Switch Row/Column, or use Chart Design > Select Data to adjust the data range and category labels.
Dates appear evenly spaced despite irregular intervals: The chart may be treating them as categories. Use an XY (Scatter) chart if the actual distance between dates should determine horizontal spacing.
The line skips a value: Check for blank cells, text stored in numeric cells, or formulas returning an empty string. Review Select Data and the Hidden and Empty Cells options, then decide whether a gap, zero, or connected segment is truthful.
One series overwhelms the others: Check whether the series use different units or scales. A secondary axis can sometimes help, but it can also make comparisons misleading. Explain clearly when separate axes are used and consider separate charts instead.
The chart changes when new data is added: Check the chart’s source range. If the source is an Excel table, added rows are generally included in the table and its chart; a chart based on a fixed cell range may not expand as expected.

Frequently Asked Questions

How do I make a line solid instead of dashed in Excel? Select the chart series, right-click and choose Format Data Series, then open Fill & Line > Line and select Solid line. If there are several series, repeat the change for each one you want to update.

Does Excel make line charts solid by default? A basic line chart commonly uses solid lines, but chart styles, themes, and prior formatting can change their appearance. Check the selected series’ line settings rather than assuming every chart has the same default.

How do I add dots to a solid line chart? Choose Line with Markers when inserting the chart, or select an existing series and change its marker options in Format Data Series. Markers and the connecting line are controlled separately, so you can show markers with a solid line or remove markers while keeping the line.

Can a line chart show gaps for missing data? Yes. Select the chart and use Chart Design > Select Data, then open Hidden and Empty Cells to review how empty cells are displayed. A gap is often the clearest choice when a value was not observed; connecting across it should be reserved for cases where that presentation is justified.

Why should I use a scatter chart instead of a line chart? Use a scatter chart when numeric horizontal values need to be spaced according to their actual values, such as irregular measurement times. A line chart generally spaces categories evenly, which is useful for ordered labels but can distort the spacing of unevenly timed observations.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.