LINEST function - Microsoft Support
The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Project values in a series - Microsoft Support
To plot a line or curve that describes existing data, use the existing x-values and y-values returned by the TREND or GROWTH function. Using the LINEST function or LOGEST function …
TREND function - Microsoft Support
The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that …
Trendline options in Office - Microsoft Support
Use this type of trendline to create a best-fit straight line for simple linear data sets. Your data is linear if the pattern in its data points looks like a line. A linear trendline usually shows that …
Draw or edit a freeform shape - Microsoft Support
To have the point treated as a straight point, press Ctrl while dragging either of the handles attached to the point. Once you stop dragging the point will be changed to a straight point. A …
Present your data in a scatter chart or a line chart - Microsoft …
In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. As a general rule, use a line chart if your data has …
Draw or delete a line or connector - Microsoft Support
Add, edit, or remove an arrow or a shape on a line. Select the line you want to change. To work with multiple lines, select the first line, and then press and hold Ctrl while you select the other …
FORECAST and FORECAST.LINEAR functions - Microsoft Support
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with …
Create a chart from start to finish - Microsoft Support
Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
Change the color, style, or weight of a line - Microsoft Support
You can change the look of a line shape by changing its color, line style, or weight. If you are using Excel, Outlook, Word, or PowerPoint, you can apply a predefined Quick Style to quickly …