To make a trendline solid in Excel for Microsoft 365 on Windows, select the trendline, press Ctrl+1, open Fill & Line in the Format Trendline pane, expand Line, and choose Solid line. If the line still looks dashed, set its Dash type to Solid as well. You can also add a trendline first if your chart does not have one.
What You’ll Need
- An Excel workbook with a chart that contains a data series. A trendline is drawn from a chart series, so you need plotted data before you can format one.
- A chart type that supports trendlines, such as an XY (Scatter), Line, or Column chart. Some chart types and data arrangements do not offer trendlines.
- Excel for Microsoft 365 on Windows for the exact ribbon paths below. Excel for Mac has similar formatting controls, while Excel for the web may offer fewer trendline options.
Step-by-Step
- Select the chart. Click once inside the chart area. The Chart Design tab should appear on the ribbon. If you cannot see that tab, click the chart again rather than a cell or worksheet object. Selecting the chart first makes it easier to add a trendline and confirm that it belongs to the intended series.
- Add a trendline if the chart does not already have one. With the chart selected, choose Chart Design > Add Chart Element > Trendline, then select a suitable type, such as Linear. For a chart with several data series, use More Trendline Options if available, or right-click the specific series and choose Add Trendline. Confirm that the trendline is attached to the series you want to analyze.
- Select the trendline itself. Click directly on the trendline, not on the data series or chart background. When selected, handles or selection markers appear along it. If the line is thin or difficult to click, use the current selection controls on the chart-format ribbon, or right-click near the line and choose Format Trendline from the menu. The formatting pane should be titled Format Trendline.
- Open the formatting pane. With the trendline selected, press Ctrl+1 on Windows. Alternatively, right-click the trendline and choose Format Trendline. If Ctrl+1 opens a pane for the data series instead, close or keep that pane open, click the trendline carefully, and try again. The object named in the pane title is a useful check that you selected the right chart element.
- Open Fill & Line. In the Format Trendline pane, click the Fill & Line icon, usually shown as a paint bucket. Expand the Line section if it is collapsed. Excel may show line controls such as color, transparency, width, compound type, and dash type. The control you need is the line setting, not the options for forecasting or choosing the trendline equation.
- Choose a solid line. Select the Solid line option. If the pane also displays a Dash type menu, open it and choose Solid. These settings control whether the trendline is drawn continuously or with gaps. If you see Automatic, Solid line, Gradient line, and No line choices, choose Solid line; do not choose No line, which hides the trendline.
- Make the result easy to see. Still in the Line settings, choose a contrasting color and adjust Width if necessary. A line that is technically solid can look faint when it is very thin, pale, or drawn over a busy chart. Use a width that remains clear at the chart’s final display size, and avoid choosing a color that blends into the chart background or data series.
- Check the chart and close the pane. Click outside the chart or close the Format Trendline pane. Confirm that the line is continuous from one end to the other and that it follows the intended data series. If it still appears broken, reopen the pane and check both the Solid line choice and Dash type. Also make sure you are looking at the trendline rather than a dashed data series.
On Mac: Select the trendline and open its formatting pane by Control-clicking or right-clicking it and choosing Format Trendline. The pane has similar Fill & Line controls; select Solid line and, if shown, choose Solid from Dash type. Ribbon labels and shortcuts can vary slightly by Excel for Mac release, so using the context menu is a dependable way to reach the pane. On Excel for the web, try selecting the trendline and using the formatting options that appear, but switch to the desktop app if the line or dash controls are unavailable.
Common Mistakes
Formatting the data series instead of the trendline. A chart series and its trendline are separate objects, and each can have a different line style. If the pane title says Format Data Series, you are changing the plotted series, not the trendline. Close or leave the pane open, select the trendline itself, and check that the pane title changes to Format Trendline before adjusting its appearance.
Changing color but not the dash setting. A new color does not make a dashed line continuous. Set Solid line and check Dash type separately if that control is available. Conversely, selecting a solid dash pattern will not make a trendline visible if No line is selected or the line is transparent.
Assuming every chart element called a line is the trendline. A chart may contain a dashed data series, a gridline, a forecast extension, and a trendline that overlap. Click the intended object and look at the pane title before editing. If the trendline is hard to select because it lies on top of a series, click an uncovered section or use the chart’s selection list to choose the trendline.
Adding a trendline to an unsuitable chart or series. Excel does not offer the same trendline choices for every chart type. If the Trendline command is unavailable, check that the chart type and selected series support trendlines. A common alternative is an XY (Scatter) chart for numeric X values; a Line chart often treats its horizontal labels as categories instead of a continuous numeric scale.
Tips
Keep the line style consistent with the message of the chart. Use a solid line when you want the trend to read as a continuous guide, and distinguish it from measured data with a different color or a modest width change. Do not rely on color alone if the chart may be printed in grayscale or viewed by people with color-vision differences. Contrast and line weight help make the trendline recognizable.
Choose the trendline model before polishing its appearance. Linear, exponential, logarithmic, polynomial, and other available models describe different patterns; making a line solid changes only its appearance, not the model or the underlying data. If the chosen model does not fit the visible pattern, a solid line will not correct that mismatch. Use a model that makes sense for the data and explain it if readers could mistake the trend for actual observations.
For a chart with multiple series, format each trendline separately. Selecting one and setting it to solid does not automatically change the others. Consider using distinct colors or widths so readers can tell which trendline belongs to which series. If you add a trendline to the wrong series, delete that trendline and add one to the intended series rather than trying to reposition it manually.
Check the chart at the size people will actually see it. A narrow solid line may look dotted when the chart is shrunk, displayed at low resolution, or printed. Slightly increasing Width can improve readability, but an overly heavy line can obscure data points. If you are preparing a report, check both the on-screen chart and a print preview or exported copy.
Troubleshooting
The Format Trendline pane does not appear. First click the chart, then click the trendline, and use Ctrl+1 or the right-click Format Trendline command. If you right-clicked the chart area or a data point, Excel may have opened a different formatting pane. Verify the pane title before proceeding. If the trendline is hidden behind another chart element, try selecting a visible portion or use the chart selection controls to locate it.
The Solid line option is missing or disabled. Make sure the selected object is an actual trendline and that the workbook is open in a desktop version of Excel with chart-formatting support. A selected data series has its own line settings, which can look similar but do not format the trendline. If you are in Excel for the web and cannot find the relevant controls, choose Open in Desktop App and apply the setting there.
The trendline still looks dashed after choosing Solid line. Expand Line again and inspect Dash type; choose Solid if the menu is present. Check transparency and width too, because a thin, partly transparent line can appear fragmented against gridlines. Zoom in on the chart and inspect it against a plain background. If the visible dashed object is actually the data series, select the trendline and format that object separately.
The trendline disappears. In the Line section, check that Solid line is selected rather than No line, and make sure its color is not the same as the chart background. Set transparency to zero or a low value if the control is available, and increase Width slightly. Also check that the trendline has not been deleted or turned off in the chart elements.
The trendline option is unavailable. Click a plotted data series rather than the chart title or legend, then look for Add Trendline. If Excel still does not offer it, try a supported chart type such as XY (Scatter), Line, or Column. Some chart types, including certain three-dimensional charts, do not support trendlines. In a PivotChart, available chart operations may be limited; a regular chart based on the underlying data may be needed.
Frequently Asked Questions
Can I make a trendline solid without changing the data?
Yes. Solid line and Dash type are formatting settings. They change how the trendline looks, not the source values, the selected model, or the calculated trend.
Why is my Excel trendline dashed by default?
A chart theme, template, copied formatting, or manual setting may give the trendline a dashed pattern. Select the trendline and set both Line to Solid line and Dash type to Solid when that menu is available.
Can I make only one of several trendlines solid?
Yes. Select the specific trendline and format it individually. Repeat the steps for any other trendline whose appearance you want to change; each trendline can have its own color, width, and dash style.
Will a solid trendline appear in a chart legend?
It can, depending on the chart and its settings. If it is not shown, select the chart and use Chart Design > Add Chart Element > Legend to show a legend. Excel’s legend behavior can vary with the chart type and how the trendline is added.
Does making the trendline solid change its equation or forecast?
No. It changes line styling only. The trendline model, equation, and any forecast settings remain as they were. To change those, select the trendline and use the options in the Format Trendline pane outside the Fill & Line section.
Related
- How to Add a Header in Excel When Printing a Worksheet
- How to Add Headers in Excel on SharePoint and Format Them
- Changing Date Format in Excel: Steps, Options, and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Percentage Chart in Excel (With Labels)To make a percentage chart in Excel, select your category labels and percentage values, then choose a chart…
- Rating Chart in Excel: Build Stars and Score ChartsTo make a five-star rating chart in Excel, enter whole-number ratings from 1 to 5 in column B,…
- Excel Not Generating Charts? Fix the Common CausesIf Excel is not generating a chart, first select a clean range that includes the labels and values,…
- Excel Waterfall Chart: Show a Total at the EndTo show a final total in an Excel waterfall chart, select the last bar, right-click it, and choose…
- Excel Payment Chart: Build a Loan Schedule and GraphAn Excel payment chart is usually a loan amortization schedule paired with a graph showing how payments are…
- How to Create a Dashboard in Excel: A Practical GuideTo create a dashboard in Excel, organize your source data in a clean table, summarize it with PivotTables…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.