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.
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?
The process shown here is trivial, i.e., select some data and press a chart option. BFD. Unfortunately, as you'll notice, the axis in the graphs shown in this "instructional video" aren't labeled. As most people with a math skill level above 6th grade will recognize, a chart without the axis labeled is pretty much useless. Well, just try to label those axis in Excel. You can left-click or right-click multiple places on the chart and open up ALL kinds of windows and specify ALL kinds of things like shadow, reflection soft edges, 3-D format, text fill, color, transparency, compound type, border, blah, blah, blah, blah, blah,...(repeat 100 times 100 TIMES!!!!),....YET, not once will you find a place where you can enter axis labels. Like most Microsoft programs, 99% of the people rarely use more than 1% of the bloated functionality provided. Unfortunately, that 1% of useful stuff is buried in the 99% of useless stuff.
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
For whatever reason, when I generate the scatter plot, it’s empty. The only thing I can get to fill in is the title
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?
You have to put a comma and not a dot as excel will not be able to read it😅
@@Ella-bt3wb Try highlighting the data set first, then insert the chart of your liking. Hope this works for you!
Your videos go to Direct in memory, once and forever. So nice presentation that it very easy to understand whatever is being explained.
Is there a way to add in a second set of data to the same graph?
Excellent presentation.
Awesome! Thank you!
Great way of explaination
Glad it was helpful :)
wow good i always see your video and it is wonderfull
I enjoyed this vedio. Thnkz for a perfect presentation ☺️
Is there a way to label each point (say Product in this video) to clearly be able to identify each point?
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.
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.
Thanks again
You are most welcome :)
I 💕 your videos !!Best explaination😍😘👌
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?
You need to highlight both columns of data and then click on insert --> then charts --> click on scatter
@@amritakang6161 life saver!!!!
Put it in individually instead of copy and paste!
My excel doesn't work like this, it wont take the data! Is this software designed to piss people off? They did a perfect job of it!
Thank you so much! Highly appreciated. Please keep up the good work.
Plz make a vedio on advanced excel in just vedio
1:47 This does not work. Instead of use values in first column it uses their idexes...
How to convert numerical values as text formate like date year month
when i for example have 8.3 it goes to the left and it doesnt read it
The process shown here is trivial, i.e., select some data and press a chart option. BFD. Unfortunately, as you'll notice, the axis in the graphs shown in this "instructional video" aren't labeled. As most people with a math skill level above 6th grade will recognize, a chart without the axis labeled is pretty much useless. Well, just try to label those axis in Excel. You can left-click or right-click multiple places on the chart and open up ALL kinds of windows and specify ALL kinds of things like shadow, reflection soft edges, 3-D format, text fill, color, transparency, compound type, border, blah, blah, blah, blah, blah,...(repeat 100 times 100 TIMES!!!!),....YET, not once will you find a place where you can enter axis labels. Like most Microsoft programs, 99% of the people rarely use more than 1% of the bloated functionality provided. Unfortunately, that 1% of useful stuff is buried in the 99% of useless stuff.
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
0:56
I HATEEEEEEEEEE EXVCELLLLLLL
This graph is a waste of time. Axis are not labelled, data points are not labelled, terrible video, disliked.
I didnt understand anything sadly
Too basic