![]() Subject to the Constraints : $B$7 >= 0, $B$7 <= 20Ĭlick on OK, and you will find that the Solver presents the same solution. The second method is to use the Solver add-in assuming you already have this installed and added to Excel, click on the Solver button when the dialog box comes up, put in the following data :Įqual To : click on the Max option button You can clearly see that the maximum value is when x = 20.Ģ. The above trendline equation is entered in column A, from A7 through A26. ![]() ![]() The issue begins in line 2 where TLEq is inconsistently left blank during the loop some iterations all the trendline equation are extracted, sometimes only some are, and other times no equations are extracted. The chart has X-values in column B, from B7 through B26. There has been no issues with graphing, trendlines showing up, or trendline equations displaying. On the chart in the uploaded workbook, the trendline equation for Series 1 is : ![]() Once you have selected the trendline option for a particular series, ensure that in the More Options dialog box for the trendline, the following checkbox is checked : To follow this, download the file, and see how things work.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |