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
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!
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 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
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?
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
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.
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.
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.
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.
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.
I’ve been struggling with making a chart for 20 minutes, this literally saved me. Thank you
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 is the best tutorial video I've ever watched.
Thank you!
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!!! I was having a headache doing this stuff... and now finally!
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
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!
You slayed thanks for helping❤️
Can anyone explain to me why whenever I do a scatter chart it charts the variables seperately?
thank you so much this made things so much easier for me
Straight to the point please
what a coincidence, im using this for my research on Douglas fir growth predictions
thank you very much for saving my time
Thank you so much, my teacher made this so hard to understand
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
GOD BLESS YOUR HEART!!!
Thank you for this video
You just saved my life, thank you so much
saved my life right there
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!
thank you so much
It's called a "Series" Yesssszzzzzss! thanks
Great video! Thankee
Perfect ASMR
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 😩😩😩😩
Life saver!
Thank you! Clearly explained!
Thank you so muchhhh.
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!
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.
Thank you
very clear and helpful
thnx for your 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
Life saver! 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 have a question, what if the data you want to show isn't numbers? i.e words?
Thank you very much. It is very useful.
Interesting and informative video....
it is still using rank values 1 2 3... as x values help me pls
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?
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
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.
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.
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.
amazing! love u sm im ur biggest fan pls notice me!
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.
How do you add another column if they aren’t next to each other
Edit Chart > Setup > Series ... Add Series
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 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"
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.
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 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.
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.
why cannot?????
i have tried and its not working
how to get the average?
how do you make a tableeeeeee
🙏
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