How to Make a Scatter Plot in Excel

Подписаться 257 тыс.

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

50% 1

Here we come with another quick and easy video tutorial on how to make a simple scatter plot in Excel, which is useful if you want to make a visual representation of a relationship between two separate sets of data. Let’s have a look at how to do that!
Watch next video tutorial:
How to visualize data in Excel
► • How to Use Color Scale...
How to Make a Graph In Excel
► • How to Make a Pie Char...
How to Add Chart Elements in Excel
► • How to Add a Title to ...
================
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
RU-vid ► www.youtube.com/@ExcelTutoria...
================
⏱️Timestamps⏱️
0:00 Intro
0:49 How to Prepare Clear Data Table in Excel Chart
1:39 How to Make a Scatter Plot in Excel
2:32 How to Modify the Plot to Achieve the Result You Need
3:45 The Dynamic Function of the Plot
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► ru-vid.com...
Transcription How to Make a Scatter Plot in Excel
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

Хобби

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

1 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Excellent presentation.

@clintwallman8400 Год назад

Awesome! Thank you!

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

Your videos go to Direct in memory, once and forever. So nice presentation that it very easy to understand whatever is being explained.

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

Great. Straight to the point. Easy to understand. Need this information because i miss 2 days of class cos of running nose. And my class mates was given an assessment to plot this chart. I was dumbfolded.

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

I 💕 your videos !!Best explaination😍😘👌

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

For whatever reason, when I generate the scatter plot, it’s empty. The only thing I can get to fill in is the title

@Ella-bt3wb 9 месяцев назад

Me too! I know this is so old but do u recall how you did it? Or were you not able to figure it out?

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

You have to put a comma and not a dot as excel will not be able to read it😅

@alshankp5590 Год назад

I enjoyed this vedio. Thnkz for a perfect presentation ☺️

@arafatfarjid1714 Год назад

Thank you so much! Highly appreciated. Please keep up the good work.

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

Great way of explaination

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

Glad it was helpful :)

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

wow good i always see your video and it is wonderfull

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

Is there a way to add in a second set of data to the same graph?

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

Thanks again

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

You are most welcome :)

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

Is there a way to label each point (say Product in this video) to clearly be able to identify each point?

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

How to convert numerical values as text formate like date year month

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

For some reason, every time I do this, I end up with a graph that is 1.2 units horizontally and 2 units vertically, with all of my data values at (0,1). Could anyone explain what I might be doing wrong and perhaps have a solution?

@amritakang6161 Год назад

You need to highlight both columns of data and then click on insert --> then charts --> click on scatter

@jainachhokar 8 месяцев назад

@@amritakang6161 life saver!!!!

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

Put it in individually instead of copy and paste!

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

Plz make a vedio on advanced excel in just vedio

@stevena139 4 месяца назад

How do you associate the dots with the products, so that you know what product represents which dot? This is not helpful without that relationship.

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

when i for example have 8.3 it goes to the left and it doesnt read it

@andriyvasilchenko3783 Год назад

1:47 This does not work. Instead of use values in first column it uses their idexes...

@yasheraa.8295 Год назад

0:56

@mahmoudwahbeh963 Год назад

Just some constructive criticism: the first minute of the video could be cut down. No useful info was shared just stating what your colomns are which isn’t the point of the video; point of the video is how to make a scatter plot