Creating an XY Scatter Plot in Excel

[@ProjectQrow]

I’ve been struggling with making a chart for 20 minutes, this literally saved me. Thank you

[@cameronhughes9707]

Can anyone explain to me why whenever I do a scatter chart it charts the variables seperately?

[@kraigshort2217]

Even the first three minutes saved my teen as he tried to submit a summer school project. Thanks!

[@georgemensah2292]

This was easily explained and clear. You saved my butt and I finally got a complex scatter plot done for different groupings in Software and their relative market TDC ratio. Thank you!

[@Vanz11011]

This is the best tutorial video I've ever watched.

[@vertex42]

Thank you!

[@theraptor8096]

This was very helpful easy to understand. There was something i was looking for that wasn't there but that might be apart of the video altogether. This will help with my assignments. Thanks

[@Not.Spooky]

Thank you so much, my teacher made this so hard to understand

[@kuwoomi4651]

You slayed thanks for helping❤️

[@danielgillett2724]

what a coincidence, im using this for my research on Douglas fir growth predictions

[@sibongiletsotetsi1211]

thank you so much this made things so much easier for me

[@wrestlingfan1232]

Straight to the point please

[@m.night_shyamamalama_sama_kun]

What an amazing level of detail in explanation and in segmenting the video...we can't thank you enough!

[@kyse2]

we need an updated video on this because my excel does not look like this 6 year old one and makes it really hard for me to follow it

[@ThePruneemac]

Thanks so much! Ive been struggling to figure out how to do scatter chart with differing data sets! My chart looks great!

[@lakshmankumara8194]

thank you very much for saving my time

[@choutzeshin8639]

Thank you so much!!! I was having a headache doing this stuff... and now finally!

[@wetelectronics7867]

It's called a "Series" Yesssszzzzzss! thanks

[@Max_Pilgrim]

1:30 As soon as I did this only 1 x-axis measurement appeared. Whereas yours (did the same exact thing I did) came up with all of your measurements in the graph/plot. The title of the graph is all of the text in the final horizontal line and the x and y values were no where near what mine were.

[@myacisneros3801]

Im having the exact same issue, do you know how to fix it

[@cookie04]

In case it still helps anybody: I had the same problem and it turns out it was because I copied the data from elsewhere. Manually entering the data solved this problem for me

[@daniellllllsdlfkj]

I think what you are describing happened to me too. I wrote my decimal values with a dot at first. When I wrote it with a comma it worked.

[@garyandrewranford]

I am sure I speak for many. I have also been looking for this as an answer to my question... multiple data patterns on the same chart. Thank you Vertex42

[@lucasekman1708]

THANK YOU Been trying to do this with the normal line chart for 2 hours and this took me literally 5 seconds

[@muhammadsyamhuseinfinsyah691]

Thank you for this video

[@GameFolder01]

Great, clear video!

[@primate6854]

You just saved my life, thank you so much

[@sonnywilliam9920]

I appreciate your work because now I've rediscovered the joy of learning computer skills, and most importantly it's fun. Thank you!

[@samla3475]

My excel is missing some of the features ('+' sign and other little squares to the right of the chart). A number of commands, functions she mentions are not in my Excel version :-(

[@nataliesanders3683]

same. i click on the graph like she says and it doesn’t highlight the data that’s on it, therefore i can’t add the new data 😩😩😩😩

[@tayfunozyurek186]

GOD BLESS YOUR HEART!!!

[@alfredkibowen9522]

Great video! Thankee

[@ratquestionmark]

saved my life right there

[@TEkYKgEY]

Thank you! Clearly explained!

[@shalyMelb]

thank you so much

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

[@heybyrd]

Thank you so muchhhh.

[@claudiaarias3299]

I don't have the little plus to add labels. I tried right-clicking on the chart, or looking up "labels" on the "Tell Me" box, but.. hitting a wall. Any reply would greatly help. Thank you

[@ishakuddin8048]

Perfect ASMR

[@doumansarouei4523]

very clear and helpful

[@kouichinakano5924]

Mine xcel is 2013 version and does not have the DESIGN tag as yours. What can I do to plot several graphs on the same chart with different x-axis values?

[@vertex42]

Right-click on the chart and choose Select Data. Then you can add other chart series (each "series" is a different graph). An XY scatter plot lets you define a separate set of X and Y values for each series.

[@LAKid8324]

Life saver!

[@thelegendsunshine119]

couldn't "drag" it as the person said so like bru. 3:07 plz help

[@vertex42]

Sometimes if you edit a chart, you'll no longer be able to drag the selector to add a new series. In that case, to add a new series, right-click on the chart and choose "Select Data". Then click on the Edit button to see how the existing series is defined (the references for the name, x values, and y values), then click on the Add button to create a new series.

[@AjeAccounting]

Interesting and informative video....

[@bramschaefers7614]

thnx for your help!!!

[@metalkokorea]

if x axis contains random numbers, do I have to array numbers in order first?

[@vertex42]

No, not in a Scatter Plot.

[@ThePijarro]

Life saver! Thank you!

[@kevinw3964]

When I plug my numbers in for some reason excel is using the column number as my x value and the number I input as my y value no matter how I label them or change them around

[@miminewbean8518]

Every time i go to add a new data 'series' it says the data is to complicated to be displayed and deletes the previously shown data

[@marmanlive]

Instead of creating separate tables for each tree, is there a way to select all trees from one table and just show tree names next to each dot on the chart as a labels ? I bet it can be achieved by creating series per tree row from the table, yet I wonder if there is a better way to do that?

[@milesminuteshouseoflove9813]

Thank you very much. It is very useful.

[@Eren-vz5vb]

it is still using rank values 1 2 3... as x values help me pls

[@selimfurkandalgic9548]

Thank you

[@franklinvirkus4972]

I don't have these tags like DESIGN, FORMAT, DEVELOPER etc. And I don't have the chart elements

[@vertex42]

The Developer tab must be added via File > Options > Customize Ribbon and checking the Developer box. The Design and Format tabs show up when you select the chart.

[@georgearias7336]

On the vertical axis, my graph shows up with a -2 right below 0, and I don't know how the heck get rid of it. I'm stuck.

[@ollies.6844]

How do you add another column if they aren’t next to each other

[@vertex42]

Edit Chart > Setup > Series ... Add Series

[@Chumbama]

How do you move vertical text (i.e tree height (meters) in the example of this video) from the left side to the right side?

[@vertex42]

Right-click on the vertical axis. Select Format Axis. Under Axis Options, expand the Labels group and in the Label Position field, select "High"

[@MentallyHygienic]

I have a question, what if the data you want to show isn't numbers? i.e words?

[@23smoothcriminal]

How do you combine the cells like where you have "douglas fir"?

[@vertex42]

You can select the cells you want to merge and then use the "Merge & Center" command on the Home ribbon.

[@amelialupi-sher3539]

amazing! love u sm im ur biggest fan pls notice me!

[@AdinaRoxanaMunteanu]

Can you add labels for the dots? e.g "trees name" ?

[@vertex42]

Yes. Click on one of the data points until only that data point is selected (two slow clicks), then right-click on the data point and select Add Data Label. Then you can select the data label and edit the text and formatting for that label. There are other methods - similar to creating a timeline chart in Excel.

[@allabout1135]

Some how I did nod get how You calculate column C. Where is comming from number in column C

[@vertex42]

It's coming from some other sample data source, not a calculation. It's just some sample data.

[@fleksimir]

If you just can't get it to work, were your cells set as the type "Text" at some point? If your cells were at some point set as Text, you cannot just change it to Number or General, Excel is too stupid for that. You have to click on each individual cell and press enter for Excel to realise "hey this is a number". Thanks Microsoft.

[@khoochuen3225]

how to get the average?

[@mariahalqubtiyah5269]

why cannot????? i have tried and its not working

[@ncdave4life]

Problem: you never mentioned which version of Excel you're using, nor which versions of Excel work like this. Mine (Excel 2010) does _NOT_ work like this.

[@gordonmallary]

how do you make a tableeeeeee

[@nasermohammadzadeh9848]

🙏

[@mohinisuratwala3957]

Kush suratwala std 7-A

[@DanielPennybaker]

Statcrunch does this much better, Microsoft is stuck in the 1990's

[@bigbigbutterfly]

Didn't work thanks

[@kiru7149]

dont care didnt ask

[@kiru7149]

im joking dont flame me