Note The trendline formula should only be used when your chart is an XY Scatter chart. This chart plots both the X axis and the Y axis as values. Line, Column, and Bar charts plot only the Y axis as values. The X axis is plotted only as a linear series in these chart types, regardless of what the labels actually are. Therefore, the trendline will be inaccurate if displayed on these types of charts. This behavior is by design.
- In the chart, select the trendline equation.
- On the Format menu, click Selected Data Labels.
- Click the Number tab, and then click Number in the Category list.
- In the Decimal places box, increase the number of decimal places to 30 so that you can see all the decimal places.
- Click OK.