Lets add a trendline to a line graph. On the Number tab click Number in the Category list and then change the Decimal placessetting to 30 or less. Two dialog boxes direct you to first select the destination cell for the formula and second select the cell for the independent variable The utility converts a trendline equation such as y 3x3 25x2 - 5x -11 into the corresponding Excel formula 3A9A3 25A9A2 - 5A9 - 11.
To use the TREND Excel Worksheet Function select a cell and type.
To use the TREND Excel Worksheet Function select a cell and type. To create a custom trendline you will pick an equation form eg. Select the whole data including Column headings. Two dialog boxes direct you to first select the destination cell for the formula and second select the cell for the independent variable The utility converts a trendline equation such as y 3x3 25x2 - 5x -11 into the corresponding Excel formula 3A9A3 25A9A2 - 5A9 - 11.