My Linest formual does not give me the second value To fix this, you can try to format the cells as General or Number and align them to the left or center You can also check this link for more tips on how to troubleshoot array formulas
Line graph with two lines that start at different x values I know how to create the two lines, but when I try to select the x-axis values, Excel defaults the second line's first point at the value at which the first line starts I have tried selecting both the whole range of x-axis values as well as each individual range, to no avail
Why does the same data get different $R^2$ using three . . . When you fix your own intercept in Excel, you force the regression line to go through the origin, which causes all kinds of havoc and can give the dreadful $R^2<0$ that you get There are some good explanations here about why that is the case and what the intercept has to do with anything
Solved: Cant add secondary values in a line chart . . . PowerBI desktop version 2 86 introduced a secondary Y axis in the line chart I am unable to drag a value in that chart I want to allow the user to select multiple values, some are total number of meetings and the other are percentages, so the scales are different
Why does Excel seemingly always calculate the wrong R^2 value . . . Whenever I calculate the R^2 value for a trendline in excel it always ends up different from the value I got when I calculated it on my TI-Nspire or an online calculator The equation of the trendline will usually end up different too, any reason to why this is?