i understand/understood the application for specific purposes, BUT, i had a academic/curious question, that why is there such a difference, for same set of data. what/how does excel give two different formula?Linearity of what? What are you measuring? what is th input (x axis value) and the output (Y axis value)
also you have very few data points so the R squared value may be artificially way to high...
I assume the line chart uses the 'trend line' option? in any case I would never that use option for anything...
I woule go with the scatter plot / standard linear regression approach at least to start. but you really need more data
You hit upon the correct answer. Substitute the integers 1 through 6 into the formula for the line graph, and the equation provides the corresponding y-values on the line graph.is it that, excel treats x-axis of line graph as some coded values 1-2-3-4-etc.,
and in scatter plot, it actually accounts for exact values of the graph variables.