Sure thing. To change the title: The first time you click anywhere on the graph, it selects the graph. After that, anything you click inside the graph is selected. It's like a drill-down process. So, click the graph, click the title, click the title again and you are "inside" the title. You will see the cursor (called the I-beam because it looks a bit like a capital letter I. If you don't see the cursor blinking, just start typing. Great question! Glad the video was helpful :)
Wondering, how so you extend the Trend Line beyond the imputed data? I would like to know what the output of heat pumps are below the data of 17 degrees that the factory provides. Thanks so much for the great teaching.
Hi, your explanation is very clear. I have Excel 2010 and I am trying to draw a regression line in the scatterplot, I try to do it according to your instructions but I do not see in my excel chart tool bar. Do you think you can help me with this?
thank you so much i missed a science class when we made the graphs for our lab data and i got so confused doing it at home cause i have the 2010 version and the school computers have an older version
I learnt a lot from this video, but the only thing that went wrong is that she did not label the axes right. The wife's age should have been on the y-axis and the husband's age on the x-axis, but she interchanged them making the labelling of the axes incorrect.
I had an exponential graph and when I selected the trendline, the line goes below x-axis which is not reasonable because the lowest point is 0. How can I fix the best fit line?
i wanna draw only one trendline for my two groups of data on a scatter chart but it is not possible! excel draws a trendline for same data. do you have any idea in this matter?
Thankyou this was very helpful; one q, how do i change the title of the legend? i.e., where you've got "wife", my plot has "series 1", "series 2", etc. thanks!
i cant get this to work, its due tomorrow, but it wants a total row in my data, but i dont have one i just want a scatter plot, but it isnt working, so this sucks...
If I would have had a teacher who could explain things as well as you do I would have graduated from college! Great video, thanks for sharing.
Sure thing. To change the title: The first time you click anywhere on the graph, it selects the graph. After that, anything you click inside the graph is selected. It's like a drill-down process. So, click the graph, click the title, click the title again and you are "inside" the title. You will see the cursor (called the I-beam because it looks a bit like a capital letter I. If you don't see the cursor blinking, just start typing. Great question! Glad the video was helpful :)
THANK YOU. YOU SAVED MY BIO HONORS ENTRY.
Very helpful video. Your efforts are much appreciated. Thank you!
I was looking on the internet how i could get such a line for like 45 minutes,, and then I find this! thanks a lot :)
Thank you, bloody excel pisses me off but this really helped! Thank you!
Wondering, how so you extend the Trend Line beyond the imputed data? I would like to know what the output of heat pumps are below the data of 17 degrees that the factory provides. Thanks so much for the great teaching.
Thanks so much, this was very helpful! Quick and two the point... great!
Fantastic tutorial!
This was so helpful! Thanks for uploading, *especially* since it's for Excel 2010. :)
Thanks for teaching me how to use microsoft.
Hi, your explanation is very clear. I have Excel 2010 and I am trying to draw a regression line in the scatterplot, I try to do it according to your instructions but I do not see in my excel chart tool bar. Do you think you can help me with this?
thank you so much i missed a science class when we made the graphs for our lab data and i got so confused doing it at home cause i have the 2010 version and the school computers have an older version
many thanks. you helped me and clear all confusion. please keep doing the same :)
Very Helpful
Thank you!
Awesome video. You make my job as an instructor easier. But there's a lot of noise and scratches.
Thank you!! very helpful :)
Glad it was helpful!
you should put on how to add the equation of the trendline, it would probably be more useful...
I learnt a lot from this video, but the only thing that went wrong is that she did not label the axes right. The wife's age should have been on the y-axis and the husband's age on the x-axis, but she interchanged them making the labelling of the axes incorrect.
I had an exponential graph and when I selected the trendline, the line goes below x-axis which is not reasonable because the lowest point is 0. How can I fix the best fit line?
Thanks for the feedback!
i wanna draw only one trendline for my two groups of data on a scatter chart but it is not possible! excel draws a trendline for same data. do you have any idea in this matter?
how do u get rid of the lines on the graph plz? the lines in the back ground?
you are treating the viewers as idiots.
we are all idiots at some point.
figured out the equation part. it's under more trendline options which is under the trendline option
Thankyou this was very helpful; one q, how do i change the title of the legend? i.e., where you've got "wife", my plot has "series 1", "series 2", etc. thanks!
how do I get the exact linear equation of that trendline?
Love you, thanks!
THANK YOU
You mean Shatner?
i cant get this to work, its due tomorrow, but it wants a total row in my data, but i dont have one i just want a scatter plot, but it isnt working, so this sucks...
high performance alert
great tut lady
Why the hell is she talking about re-sizing the graph when all we need is to know how to make the damn scatterplot graph??
im not saying this guide sucks at all im saying that my excel 2010 wont work sucks lol this guide is great idk why mine isnt working
which one its Y and X?
X is the independent data and Y is the dependent data
O GOD HER VOICE :(
hi you did a mistake in axis lable, x axis is husband's age and y axis is wife's age
@fr0zenova hahhahahhaha
no offence but you talk too much for no reason