Excel: Two Scatterplots and Two Trendlines

Here we add two series in one scatter plot, and make separate trendlines for them.
Download File Used: docs.google.co...
Excel Video Playlist 1: • Excel Videos
Excel Video Playlist 2: • Short Excel Videos: Bu...
My Website: www.burkeyacade...
Support me on Patreon! / burkeyacademy
Talk to me on my SubReddit: / burkeyacademy
Buy me a cup of coffee on PayPal? paypal.me/Burke...

[@jennyrose5543]

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]

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

[@user-fm8tn6cw2e]

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

[@penisbumpkin3315]

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

[@hildagakure3167]

Thank you for breaking it in a very easy way

[@jacquelinefrancis8127]

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

[@joshuakaufmann4081]

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

[@mintupal957]

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

[@rohanchacko2132]

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

[@Mr_T4C05]

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

[@HooterGeuse]

The past series data trick is amazing!

[@soorajahmadkargar7246]

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

[@88spaces]

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

[@somukienibilly1456]

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

[@Sarah-rl1ut]

Thank you good sir

[@KJB025]

Thank you so much for this!

[@tommorley7006]

You helped me on my assignment, thank you.

[@carlosrolandofernandezpuli1238]

I love you man, you just saved me

[@Akash_Tyagi_93]

Thanks a ton. Excellent video.

[@bc931]

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

[@cassyaalmeida4713]

tks from Brazil!

[@sharonsawe7128]

This was so helpful today! Thank you!

[@endringresi9181]

Very valuable thank you

[@alecbeans6886]

3:30 life saver

[@melissaedmondson5956]

Very helpful. thanks!

[@expelleddux]

You're a legend

[@oladamola8690]

Thank you so much. This video was really helpful

[@user-hh4nc4fe6u]

Extremely helpful! Thank you!

[@KyleTriathLane]

Thank you Sir

[@alexandralile754]

You rock, thank you!!

[@Macchiatrooper]

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

[@leahvanlandingham3366]

Very helpful, thank you!

[@ammarhassan6914]

Very helpful thanks.

[@kavikumar816]

you help me so I leave a like

[@f.h.z]

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

[@doctort2853]

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]

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

[@eddyrealon1105]

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

[@thuongnguyen8413]

Thank you so much sir!

[@f.h.z]

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

[@AmitKumar-ws1rw]

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

[@VSP4591]

Splendid.

[@908572813]

simply great!
tnx

[@phantomgt.]

3:00 onwards

[@parijatshrivastava]

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.

[@by7991]

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

[@su9739]

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

[@ankitagoel7445]

Its Awesome. thankx a ton:)

[@wai6661]

thank you so much🤙🤙

[@andycandy7747]

Thanks brotha

[@jonotas3534]

Thank You!!!

[@flordelarama8248]

thank you!

[@mirawray6358]

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

[@domgrace3058]

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

[@World_Exploria]

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]

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.

[@rashravshrestha5218]

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!

[@nandarawtani6202]

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

[@arshiabnz258]

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

[@BurkeyAcademy]

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]

@@BurkeyAcademy how to combine the dAtasets

[@HarryPotter-xo9ec]

Your voice just like tony stark

[@JasonActualization]

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]

In Excel the slope command will calculate the slope.

[@JasonActualization]

@@BurkeyAcademy Thank you!

[@fueledbyfitness4444]

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]

sorry "Make and Model"

[@BurkeyAcademy]

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. th-cam.com/video/jbv68cEEee8/w-d-xo.html

[@elamigodeunexperto]

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]

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.

[@HM-wj4je]

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

[@gaatjeniksaan336]

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?

[@debeshhait9119]

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

[@BurkeyAcademy]

I don't understand what you want to do.

[@saunokchakrabarty8384]

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

[@freddyincarnation456]

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

[@najmiimran6137]

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

[@BurkeyAcademy]

The link is at the top of the video description.

[@jamestipalan2527]

HOW TO MAKE SCATTER PLOT ABOUT X AND Y

[@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

[@MrRosssy]

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

[@BurkeyAcademy]

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

[@salimtheone]

How to add only one Trendline for both Scatterplots ??

[@BurkeyAcademy]

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.

[@maheshmb9306]

Is there any option to combine these trend lines?

[@BurkeyAcademy]

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

[@falconeye577]

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]

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]

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]

Here is your video... th-cam.com/video/mNd52jRTYWM/w-d-xo.html

[@theodorenkhoma9492]

Is it just me or does he sound bit like Sal Khan?

[@SamiKhan-pb4qb]

Thank you sir

[@nep4912]

very helpful, thank you