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

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

[@kraigshort2217]

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

[@Vanz11011]

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

[@vertex42]

Thank you!

[@lucasekman1708]

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

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

[@m.night_shyamamalama_sama_kun]

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

[@choutzeshin8639]

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

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

[@cameronhughes9707]

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

[@ThePruneemac]

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

[@kuwoomi4651]

You slayed thanks for helping❤️

[@wrestlingfan1232]

Straight to the point please

[@sibongiletsotetsi1211]

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

[@danielgillett2724]

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

[@sonnywilliam9920]

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

[@Not.Spooky]

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

[@lakshmankumara8194]

thank you very much for saving my time

[@ishakuddin8048]

Perfect ASMR

[@tayfunozyurek186]

GOD BLESS YOUR HEART!!!

[@muhammadsyamhuseinfinsyah691]

Thank you for this video

[@primate6854]

You just saved my life, thank you so much

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

[@wetelectronics7867]

It's called a "Series" Yesssszzzzzss! thanks

[@shalyMelb]

thank you so much

[@ratquestionmark]

saved my life right there

[@TEkYKgEY]

Thank you! Clearly explained!

[@GameFolder01]

Great, clear video!

[@ConspiracytardHunter420]

thanks yo u helped me with my physics lab

[@LAKid8324]

Life saver!

[@alfredkibowen9522]

Great video! Thankee

[@selimfurkandalgic9548]

Thank you

[@heybyrd]

Thank you so muchhhh.

[@doumansarouei4523]

very clear and helpful

[@bramschaefers7614]

thnx for your help!!!

[@ThePijarro]

Life saver! Thank you!

[@milesminuteshouseoflove9813]

Thank you very much. It is very useful.

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

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

[@AjeAccounting]

Interesting and informative video....

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

[@nasermohammadzadeh9848]

🙏

[@Eren-vz5vb]

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

[@amelialupi-sher3539]

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

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

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

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

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

[@metalkokorea]

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

[@vertex42]

No, not in a Scatter Plot.

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

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

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

[@MentallyHygienic]

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

[@ollies.6844]

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

[@vertex42]

Edit Chart > Setup > Series ... Add Series

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

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

[@mohinisuratwala3957]

Kush suratwala std 7-A

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

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

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

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

[@khoochuen3225]

how to get the average?

[@gordonmallary]

how do you make a tableeeeeee

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

[@DanielPennybaker]

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

[@kiru7149]

dont care didnt ask

[@kiru7149]

im joking dont flame me