First things first. Even if you have all values in column C the trendline will be plotted wrong as your X axis is not linear. You have data 0..15 in 1 increments (so far, so good), but then 17 and 21 (16 and 18,19,20 missing).
Now the second point - such values of R2 probably mean that there is no significant correlation between values you try to plot. Have you tested the hypotesis about correlation presence? If there is no significant correlation, no regression (trend) line shall be plotted. You can as well draw a random line . But let's skip this point.
Once you have the missing rows added, you can calculate the regression line with formulas
now you can calculate 2 points laying on the regression line. for instance for x1 = -0.5 and x2=21.5 (these are x coordinates of left and right edges of the plot) using simple
and copied down
N7 and N8 the slope and intercept values, M10 and M11 x1 and x2
Now you add new series to the plot. make sure this series is scatterplot type plotted on secondary axis. You select thuis secondary axis on the drawning and delete it. And final touch Add labels to your points using the regression line and Rsquared text:
or if you (as you probably have in your system) have international character set and ascii 253 is visible as y with dash.
The ladies part shall be done the same way.
Bookmarks