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!
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
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.
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
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
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 :-(
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!
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
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?
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.
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?
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.
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
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.
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.
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.
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.
I’ve been struggling with making a chart for 20 minutes, this literally saved me. Thank you
Can anyone explain to me why whenever I do a scatter chart it charts the variables seperately?
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!
Even the first three minutes saved my teen as he tried to submit a summer school project. Thanks!
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
This is the best tutorial video I've ever watched.
Thank you!
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.
Im having the exact same issue, do you know how to fix it
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
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.
You slayed thanks for helping❤️
THANK YOU
Been trying to do this with the normal line chart for 2 hours and this took me literally 5 seconds
Thank you so much, my teacher made this so hard to understand
thank you so much this made things so much easier for me
What an amazing level of detail in explanation and in segmenting the video...we can't thank you enough!
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
Thanks so much! Ive been struggling to figure out how to do scatter chart with differing data sets! My chart looks great!
Thank you so much!!! I was having a headache doing this stuff... and now finally!
thank you very much for saving my time
Thank you for this video
You just saved my life, thank you so much
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 :-(
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 😩😩😩😩
what a coincidence, im using this for my research on Douglas fir growth predictions
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
Straight to the point please
I appreciate your work because now I've rediscovered the joy of learning computer skills, and most importantly it's fun. Thank you!
Great, clear video!
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!
It's called a "Series" Yesssszzzzzss! thanks
Thank you! Clearly explained!
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
thank you so much
Great video! Thankee
GOD BLESS YOUR HEART!!!
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?
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.
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?
it is still using rank values 1 2 3... as x values help me pls
saved my life right there
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
if x axis contains random numbers, do I have to array numbers in order first?
No, not in a Scatter Plot.
couldn't "drag" it as the person said so like bru. 3:07 plz help
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.
Thank you so muchhhh.
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
very clear and helpful
How do you add another column if they aren’t next to each other
Edit Chart > Setup > Series ... Add Series
Perfect ASMR
Can you add labels for the dots? e.g "trees name" ?
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.
I have a question, what if the data you want to show isn't numbers? i.e words?
Life saver!
How do you combine the cells like where you have "douglas fir"?
You can select the cells you want to merge and then use the "Merge & Center" command on the Home ribbon.
thnx for your help!!!
Life saver! Thank you!
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?
Right-click on the vertical axis. Select Format Axis. Under Axis Options, expand the Labels group and in the Label Position field, select "High"
Thank you
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.
I don't have these tags like DESIGN, FORMAT, DEVELOPER etc. And I don't have the chart elements
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.
Interesting and informative video....
Thank you very much. It is very useful.
Some how I did nod get how You calculate column C. Where is comming from number in column C
It's coming from some other sample data source, not a calculation. It's just some sample data.
how to get the average?
amazing! love u sm im ur biggest fan pls notice me!
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.
how do you make a tableeeeeee
why cannot?????
i have tried and its not working
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.
🙏
Kush suratwala std 7-A
Statcrunch does this much better, Microsoft is stuck in the 1990's
Didn't work thanks
dont care didnt ask
im joking dont flame me