Note that, it is not essential that the supplied points fit exactly along the straight line y = 2x + 10, (although they do in this example). The known x- and y-values are stored in cells A2-B5 of the spreadsheet, and are also shown in the spreadsheet graph.
In the spreadsheet below, the Excel Trend Function is used to extend a series of x- and y-values that lie on the straight line y = 2x + 10. Trend Function Examples Example 1 - Extension of a Simple Straight Line Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.See the Excel Array Formulas page for further details. To input an array formula, you need to first highlight the range of cells for the function result. Therefore, the function must be entered as an Array Formula (see the examples below). If more than one new y-value is to be calculated by the Excel Trend function, the new values will be returned as an array. If is FALSE the constant b is set to 0 and the straight line equation becomes y = mx. If is TRUE (or if this argument is omitted) the constant b is treated normally
Īn optional logical argument that specifes whether the constant 'b', in the straight-line equation y = mx + b, should be forced to be equal to zero. If the argument is omitted, it is set to be equal to the. Īn optional argument, providing one or more arrays of numeric values representing a set of new x-values, for which you want to calculate the corresponding new y-values.Įach array of should correspond to an array of. If omitted, the set of takes on the value. This is an optional argument which, if provided, should have the same length as the set of known_y's. Where the function arguments are as follows: known_y's To help you further, c ould you provide the version of your Excel? You can go to Excel File > Account > Product Information and provide the screenshot of it.TREND( known_y's,, , ) Please click on the link below to access your private message:Īt the same time, you can create a new Excel file, then copy the content of problematic file and paste it to the new file to check if the same problem will occur.
I will send you the Excel file I created via private message. The blue and gray maps do not show the Exponential trendline because the y-axis is empty and has no value. Q & WE Stats Sheet and pasted it to the new Excel file, then I inserted the chart according to the chart in your file. I created a new Excel file, then I copied the content ofĬont. I have tested it again according to the file you provided, as results shown below:
* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here. * Beware of scammers posting fake support numbers here. If you want to present Exponential trendline, please make sure your data doesn’t As shown below:įor more details, you can refer to this article: Add a trendįor other scatter plots where the y-axis doesn’t include zero, Exponential trendline can be displayed. An exponential trendline is not available when your data includes negative or zero values. > selected Exponential in Trendline and it can show normally, as shown below:Īt the same time, I noticed that there are two sets of data graphs that cannot display Exponential trendline, this may be because your y-axis data is 0. I selected the first chart > then I clicked Chart Design > clicked Select Data > click Add and edit the data range of Series X values and Series Y values, as shown below: Thank you for the Excel file you provided in private message. Sukie - * Beware of scammers posting fake support numbers here. Please click on the link below to access your private message: If it only occurs in a specific file, I want to collect the problematic excel file with you via private message.
Update history for Office 365 ProPlusto achieve the latest version of Office) and I cannot reproduce the situation as same as yours. I have tested it with my latest version of Excel(You can refer to this article: Thank you for your message in this forum.