Excel 2007. I have, to say, 5 data sets and 5 lines on the graph. All of them have the different intervals on the x axes. I want make the trend lines for each set of data. Excel creates these 5 trend lines readily, but the lengths of all trend lines are identical and are determined by the minimal and maximal value of arguments in all 5 data sets. How can one make the length of trend line to correspond to the length of the respective data set only? David, dkbel75@gmail.com
Solved by A. A. in 27 mins