Excel: Two Scatterplots and Two Trendlines

Просмотров 256 тыс.

% 1 833

Here we add two series in one scatter plot, and make separate trendlines for them.
Download File Used: docs.google.com/spreadsheets/d/0B3-F8BTZSbH9eWpXaGJDUjhBWHc/edit?usp=sharing
Excel Video Playlist 1: ru-vid.com/group/PLlnEW8MeJ4z6nn2_bW9_VpjyGVF4cYPoK
Excel Video Playlist 2: ru-vid.com/group/PLlnEW8MeJ4z53d03VzKP9uUePeFiNMhyW
My Website: www.burkeyacademy.com/
Support me on Patreon! www.patreon.com/burkeyacademy
Talk to me on my SubReddit: www.reddit.com/r/BurkeyAcademy/
Buy me a cup of coffee on PayPal? paypal.me/BurkeyAcademy

Опубликовано:

26 апр 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 95

@jennyrose5543 5 лет назад

Thank you so much! I needed to add two trendlines to one Excel graph and could not figure out how to do it. Your video helped tremendously!

@lee-yongtay8876 2 года назад

Thank you very much :-) Always wondered how to put two separate data and lines into one excel graph :-). Very easy to understand and follow.

@joshuakaufmann4081 3 года назад

I needed to make a scatterplot real quick for some data at work. It was very helpful knowing were to go . thanks.

@penisbumpkin3315 4 года назад

thank you so much sir. You have no idea how hard unintuitive Microsoft programs can seem at times.

@user-fm8tn6cw2e 5 месяцев назад

Brilliant simple straight forward no nonsense epic tutorial ! Loved it. Thank you

@rohanchacko2132 3 года назад

Thank you for this man. I was looking for this all over the place

@88spaces 4 года назад

Thank you. I was having trouble with this and you made it easy for me.

@jacquelinefrancis8127 2 года назад

Brilliant. So good to know how to do this in Excel rather than using the SPSS graphs.

@hildagakure3167 2 года назад

Thank you for breaking it in a very easy way

@somukienibilly1456 11 месяцев назад

Many thanks for making this tutorial easy to understand. It's awesome!

@HooterGeuse 3 года назад

The past series data trick is amazing!

@soorajahmadkargar7246 5 месяцев назад

have been looking for this for an hour. thank you so much !

@tommorley7006 3 года назад

You helped me on my assignment, thank you.

@f.h.z 5 лет назад

Very helpful, thanks a lot for this. Could you make a video or explain how to create an Interactive one please?

@israellaragarcilazo3515 5 месяцев назад

Thank you so much!!!!!!!! I spent a lot of time trying to solve this problem

@bc931 5 лет назад

Thank you so much for explaining things so clearly!! You're a lifesaver!

@Macchiatrooper 4 года назад

thanks for the help in this - was a great assist!

@user-hh4nc4fe6u Год назад

Extremely helpful! Thank you!

@sharonsawe7128 9 месяцев назад

This was so helpful today! Thank you!

@leahvanlandingham3366 5 лет назад

Very helpful, thank you!

@oladamola8690 4 года назад

Thank you so much. This video was really helpful

@Akash_Tyagi_93 2 года назад

Thanks a ton. Excellent video.

@KJB025 3 месяца назад

Thank you so much for this!

@melissaedmondson5956 3 года назад

Very helpful. thanks!

@alexandralile754 3 года назад

You rock, thank you!!

@carlosrolandofernandezpuli1238 7 месяцев назад

I love you man, you just saved me

@nep4912 4 года назад

very helpful, thank you

@mintupal957 3 года назад

Thanks a lot for this video, I really need the exact one,. ❤️❤️ From INDIA.

@endringresi9181 3 года назад

Very valuable thank you

@cassyaalmeida4713 5 месяцев назад

tks from Brazil!

@AmitKumar-ws1rw 6 лет назад

Thank you so much for this video. Keep going (Y)

@908572813 4 года назад

simply great! tnx

@VSP4591 4 года назад

Splendid.

@nandarawtani6202 2 года назад

Thank you very much! Does this mean there can be more than two data sets , say 3? Will the procedure remain the same?

@thuongnguyen8413 3 года назад

Thank you so much sir!

@expelleddux Год назад

You're a legend

@Sarah-rl1ut 3 года назад

Thank you good sir

@andycandy7747 5 лет назад

Thanks brotha

@parijatshrivastava 7 месяцев назад

Thank you! was hoping to insert multiple scatter plots & superimpose each data sets trendlines. Wondering if there is a way to arrive at a single unified trendline based on individual trendlines?? Or is there another statistical concept which applies to achieve this.

@jonotas3534 4 года назад

Thank You!!!

@f.h.z 5 лет назад

Is this possible to do only with 2, not for >2 scatterplots in the same? Thanks

@KyleTriathLane 4 года назад

Thank you Sir

@eddyrealon1105 3 года назад

How can I do scatterplot with categorical / ordinal data in the X axis?

@flordelarama8248 4 года назад

thank you!

@gaatjeniksaan336 6 лет назад

I have to make a spread chart with 76474 values, when i make the chart it is only showing some dots. How to make it properly?

@saunokchakrabarty8384 5 лет назад

can I remove the "Linear Domestic" part from the legend?

@wai6661 4 года назад

thank you so much🤙🤙

@ankitagoel7445 3 года назад

Its Awesome. thankx a ton:)

@alecbeans6886 4 года назад

3:30 life saver

@HM-wj4je 4 года назад

This is great. But I want to show data level in tooltip. How I can do that?

@su9739 2 года назад

How to use different symbols e.g triangle, square, diamond etc for different series instead of different colours round dots.

@domgrace3058 4 года назад

i’m trying to do one but because i have so many points the scatter graph only gives a proportion of my info i want all of it what should i do

@MrRosssy 7 лет назад

Thank you! Only question I had is is there a way to make the trend lines as slopes instead of linear?

@BurkeyAcademy 7 лет назад

Can you clarify the question? I don't get it. Trend lines have slopes... I can't figure out "as slopes instead of lines".

@by7991 Год назад

If I want to rationalize frieghts in particular distance slab.. how this works ..

@kavikumar816 Год назад

you help me so I leave a like

@doctort2853 3 года назад

Hi, looking closely the dots of import is on top of the domestic ones. If I want to specifically set one to be on top, is there a quick way to do it? thanks!

@doctort2853 3 года назад

I found the answer. By default, the second series would be on top. Simply rearrange the series.

@freddyincarnation456 5 лет назад

Paste special is not available for me after I copied the data. Helpppp

@mirawray6358 Год назад

how did you get the colours to change? mine stays blue even after I do your steps

@arshiabnz258 3 года назад

Great explanation! Do you know how to combine the two trendlines to get one master trendline for the entire data?

@BurkeyAcademy 3 года назад

I think that the easiest thing would be to combine both into a third dataset, and add that trendline. You can hide those points by making their dot color "no color".

@sajivesivalingam7360 3 года назад

@@BurkeyAcademy how to combine the dAtasets

@rashravshrestha5218 3 года назад

When I click edit series, It doesn't allow me to enter X and Y series values. It just has to field to enter series values (Doesn't specify x and y values. How can I solve this pls help!

@jamestipalan2527 5 лет назад

HOW TO MAKE SCATTER PLOT ABOUT X AND Y

@fueledbyfitness4444 6 лет назад

Is there a way to have the Model and Type included in the dot when you hover over it? This would make it easy to distinguish what the dots in the graph represent.

@fueledbyfitness4444 6 лет назад

sorry "Make and Model"

@BurkeyAcademy 6 лет назад

I am not sure how to get it to do both of those, but I have a video with a few ideas that might help you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jbv68cEEee8.html

@HarryPotter-xo9ec 4 года назад

Your voice just like tony stark

@World_Exploria 5 лет назад

Hello Dear, I want to Plot two independent variables such soil organic matter and soil nitrogen and dependent variable Nitrogen use efficiency (NUE) on one graph with two trend lines but it show different R square value when i plotted this data separately (soil Nitrogen and NUE and Soil organic matter and NUE ) what is the actual reason ?

@BurkeyAcademy 5 лет назад

Because with two data sets and two trendlines, you will have two different R^2 values. The R^2 tells you how well the lines fit the data, on a scale from 0 to 1.

@JasonActualization 11 месяцев назад

Amazing! Any idea how to reference the slope of the trendline equation in a separate cell? For example, I'd like to incorporate the slope of the trendline into a separate formula, but don't know how to refer to it so that it updates with any changes to the trendline.

@BurkeyAcademy 11 месяцев назад

In Excel the slope command will calculate the slope.

@JasonActualization 11 месяцев назад

@@BurkeyAcademy Thank you!

@elamigodeunexperto 6 лет назад

Good video friend. I have one question, i want to change the shape of the dots for each serie because i am going to print my paper in white and black, so I need to distinguish one from the other. thank you

@BurkeyAcademy 6 лет назад

Left click one of the points, then right click, Format Data Point. Then click the bucket to change the color, click on Marker to change the shape.

@debeshhait9119 3 года назад

I want to change y=mx+c to y=-mx+c in excel scatter plot! How to do convert of the inverse diagram?

@BurkeyAcademy 3 года назад

I don't understand what you want to do.

@najmiimran6137 3 года назад

hello, first of all tq for the knowledge. May i know where to ge the link for this dataset?

@BurkeyAcademy 3 года назад

The link is at the top of the video description.

@maheshmb9306 4 года назад

Is there any option to combine these trend lines?

@BurkeyAcademy 4 года назад

Sure, just combine both datasets together, and add a third trendline using the combined data.

@salimtheone 5 лет назад

How to add only one Trendline for both Scatterplots ??

@BurkeyAcademy 5 лет назад

The easiest way is to probably graph three sets of points: First all the points, and add the trendline. Then change the point type to None, and add the other two groups separately.

@phantomgt. 2 года назад

3:00 onwards

@Quetzal00358 Год назад

Is it possible to do this but keep only the lines? Is it possible to remove the scatter plots but keep the trendiness?

@BurkeyAcademy Год назад

Sure, just tell it to make the points "no color" (or called something similar) under the color options.

@Quetzal00358 Год назад

@@BurkeyAcademy Thank you. Is there a way to get rid of the labels for the points? I try adding a trend line and it says Linear (*insert data*) and it has the names of the data sets next to where the colored points would be on the legend. I can't figure out what to do

@falconeye577 6 лет назад

ok, Master of the Trend Lines I went to a MAJOR amount of work to create what I wanted, but there must be an easier way What I want is a Trend line (straight line) with a second and third trend line, each parallel to the original trend line, one 15% above and one 15% below the Median (or Average) of the value of the original line As I said, I was able to do it, but it was a ton of work So, what is the easy way

@BurkeyAcademy 6 лет назад

I don't know of a VERY easy way. but it doesn't seem too bad... I'll make a quick video here and you can see what you think...

@falconeye577 6 лет назад

I can email you the spreadsheet I did it on, but as I said,m it is a lot of work and there must be an easier way

@BurkeyAcademy 6 лет назад

Here is your video... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mNd52jRTYWM.html