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.

[@KreedaRudraaksh]

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

[@rohanchacko2132]

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

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

[@soorajahmadkargar7246]

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

[@hildagakure3167]

Thank you for breaking it in a very easy way

[@Mr_T4C05]

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

[@88spaces]

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

[@HooterGeuse]

The past series data trick is amazing!

[@somukienibilly1456]

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

[@carlosrolandofernandezpuli1238]

I love you man, you just saved me

[@tommorley7006]

You helped me on my assignment, thank you.

[@sharonsawe7128]

This was so helpful today! Thank you!

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

[@mintupal957]

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

[@darth2wicked]

Thank you I had to break out the scatter plot into it's individual components

[@Akash_Tyagi_93]

Thanks a ton. Excellent video.

[@eddyrealon1105]

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

[@Dogtuah]

3:30 life saver

[@f.h.z]

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

[@bc931]

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

[@f.h.z]

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

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

[@КиндАлександр]

Extremely helpful! Thank you!

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

[@cassyaalmeida4713]

tks from Brazil!

[@Macchiatrooper]

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

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

[@expelleddux]

You're a legend

[@mirawray6358]

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

[@KJB025]

Thank you so much for this!

[@su9739]

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

[@by7991]

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

[@melissaedmondson5956]

Very helpful. thanks!

[@oladamola8690]

Thank you so much. This video was really helpful

[@endringresi9181]

Very valuable thank you

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

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

[@alexandralile754]

You rock, thank you!!

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

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

[@nandarawtani6202]

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

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

[@nep4912]

very helpful, thank you

[@Wander_vista-u5s]

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.

[@leahvanlandingham3366]

Very helpful, thank you!

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

[@saunokchakrabarty8384]

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

[@KyleTriathLane]

Thank you Sir

[@freddyincarnation456]

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

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

[@thuongnguyen8413]

Thank you so much sir!

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

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

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

[@kavikumar816]

you help me so I leave a like

[@AmitKumar-ws1rw]

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

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

[@908572813]

simply great!
tnx

[@VSP4591]

Splendid.

[@wai6661]

thank you so much🤙🤙

[@ankitagoel7445]

Its Awesome. thankx a ton:)

[@jamestipalan2527]

HOW TO MAKE SCATTER PLOT ABOUT X AND Y

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

[@andycandy7747]

Thanks brotha

[@jonotas3534]

Thank You!!!

[@HarryPotter-xo9ec]

Your voice just like tony stark

[@flordelarama8248]

thank you!

[@phantomgt.]

3:00 onwards

[@theodorenkhoma9492]

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

[@Sarah-rl1ut]

Thank you good sir

[@ammarhassan6914]

Very helpful thanks.

[@SamiKhan-pb4qb]

Thank you sir