You want to add a trendline equation to a chart in PowerPoint so you can see the slope, intercept, or other coefficients. PowerPoint can display the equation directly on the chart, but the default formatting often hides the full precision or makes the equation hard to read. This article explains how to add a trendline, show its equation, and format the equation box to display all coefficients clearly.
PowerPoint uses the same charting engine as Excel, so you can apply linear, exponential, logarithmic, polynomial, or moving average trendlines. Each trendline type produces a different equation format. You will learn how to enable the equation display, adjust decimal places, and move the equation box for better visibility.
This guide covers PowerPoint for Microsoft 365, PowerPoint 2021, and PowerPoint 2019. The steps are identical across these versions.
Key Takeaways: Adding and Formatting Trendline Equations in PowerPoint
- Chart Tools > Design > Add Chart Element > Trendline > More Trendline Options: Opens the Format Trendline pane where you choose the trendline type and enable the equation.
- Format Trendline pane > Display Equation on chart checkbox: Shows the equation directly on the chart area as a text box.
- Right-click the equation box > Format Trendline Label > Number > Decimal places: Increases or decreases the number of decimal places shown for each coefficient.
Why PowerPoint Displays Trendline Equations With Limited Decimal Places
When you add a trendline equation to a chart, PowerPoint automatically formats the coefficients with a small number of decimal places, typically two. This default setting makes the equation short and readable on small charts. However, for scientific, engineering, or financial presentations, two decimal places often hide important precision. The equation box is a standard text box that you can resize, move, and reformat independently from the chart. PowerPoint does not adjust the decimal places based on the data range; it uses a fixed format. You must manually change the number format of the equation label to show more digits.
Steps to Add a Trendline and Display Its Equation
Follow these steps to add a trendline to any chart in PowerPoint and show the equation coefficients.
- Select the chart
Click the chart to which you want to add a trendline. The Chart Tools contextual tabs appear on the ribbon. - Open the Add Chart Element menu
On the ribbon, click the Chart Design tab. In the Chart Layouts group, click Add Chart Element. Point to Trendline and select the type of trendline you want, such as Linear, Exponential, or Moving Average. If you need a polynomial trendline, select More Trendline Options at the bottom of the list. - Choose the trendline type and enable the equation
In the Format Trendline pane that opens on the right side of the window, select the trendline type under Trendline Options. For a polynomial trendline, set the Order number. Scroll down and check the box labeled Display Equation on chart. The equation appears on the chart inside a text box. - Move and resize the equation box
Click the equation box to select it. Drag it to a blank area of the chart to avoid overlapping with data points or axis labels. Drag a corner handle to enlarge the box so the full equation is visible.
Format the Trendline Equation to Show More Decimal Places
- Right-click the equation box
Click the equation text box with the right mouse button. A context menu appears. - Open the Format Trendline Label pane
From the context menu, select Format Trendline Label. A separate pane opens on the right side of the window. - Change the number format
In the Format Trendline Label pane, click Number to expand the section. Under Category, select Number. In the Decimal places box, type the number of decimal places you want, such as 6 or 10. The equation updates immediately on the chart. - Close the pane
Click the Close button (X) in the upper-right corner of the pane. The equation now displays the coefficients with your chosen precision.
Common Issues When Working With Trendline Equations in PowerPoint
The Equation Box Shows Only the First Few Characters
The equation box has a fixed width. If the equation is long, such as a 6th-order polynomial, the box truncates the text. Click the equation box and drag a corner handle to make the box wider. You can also increase the font size of the equation label by selecting the box and using the Home tab Font group to set a smaller font size, which fits more text.
The Equation Disappears When You Change the Chart Type
If you switch the chart type after adding a trendline, PowerPoint removes the trendline and its equation. Add the trendline again after changing the chart type. To avoid this problem, finalize the chart type before adding the trendline.
The Trendline Equation Does Not Match the Data
A trendline equation is a best-fit calculation based on the data points in the series. If the data contains empty cells, text, or error values, the trendline may skip those points. Ensure the source data is numeric and continuous. For polynomial trendlines, an order that is too high can produce an equation that overfits the data. Use the lowest order that provides a reasonable fit.
PowerPoint Trendline Equation Display Options
| Trendline Type | Equation Format | Decimal Place Control |
|---|---|---|
| Linear | y = mx + b | Yes, via Format Trendline Label |
| Exponential | y = a e^(bx) | Yes, via Format Trendline Label |
| Logarithmic | y = a ln(x) + b | Yes, via Format Trendline Label |
| Polynomial (order 2 to 6) | y = ax^n + … + c | Yes, via Format Trendline Label |
| Moving Average | No equation displayed | Not applicable |
The Moving Average trendline does not produce an equation because it is a smoothed line based on averaged data points. All other trendline types support the Display Equation on chart option. The equation format changes based on the trendline type, but the method to adjust decimal places is identical for all types.
You can now add a trendline to any PowerPoint chart, show the equation, and adjust the number of decimal places for each coefficient. For presentations that require precise data analysis, increase the decimal places to at least six. To copy the equation into another application, select the equation box, press Ctrl+C to copy, and paste into Excel or Word. The equation pastes as plain text.