This can cause a trend to appear to be incorrect. However, the accuracy of the chart is significantly reduced. This behavior allows the equation to occupy less space in the chart area. For appearance, each X value is rounded off to the number of significant digits that are displayed in the chart. Microsoft Excel plots trendlines incorrectly because the displayed equation may provide inaccurate results when you manually enter X values. Therefore, the trendline will be inaccurate if it is displayed on these types of charts. In these chart types, the X axis is plotted as only a linear series, regardless of what the labels actually are. Line, Column, and Bar charts plot only the Y axis as values. This chart plots both the X axis and Y axis as values. In my experience I was unable to tell it to just use all column values (A:A) without it failing somehow, so I had to set some arbitrary limit (A1:A1000) for it to work.įormat the cell you put this formula in as Date and you'll get a prediction as to when your number of installs will equal the number of users.The trendline formula is used for an XY Scatter chart. So if your dates are in column A and the TOTAL number of successful updates is in column B, and you've got less than a thousand values entered already, you'll put the following formula in a spare cell somewhere: =FORECAST(660, A1:A1000, B1:B1000) In your case X equals 660, Yrange is the Date, and Xrange is the Number of Successful Updates. The syntax is: =FORECAST(X, Yrange, XRange) The solution does not involve the graph, it uses the FORECAST() function of Excel. I did this in a spreadsheet I was using to track Backup growth at a previous job.
If you're looking for a predicted DATE when the Number Updated reaches 660, you need to write some formulas.
0 kommentar(er)
