But they do document it in ( click here). I would agree that Microsoft could document this better. To do this, right-click the formula box on the chart Ĭlick Format Trendline Label change Category to Number and increase the number of decimal places. You need more digits for the formula to be useable (in my case, the accuracy was enough, except that it went into scientific number format so the 5 digits just showed the E01.1 and that was about it). The chart MUST be "X Y Scatter" type - it isn't in the insert chart options, you have to insert a chart, click Change Chart Type, then change to X Y Scatter.ģ. It's Microsoft's fault their formula works, but only if you do certain things.Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |