Excel: How to Identify a Point in a Scatter Plot
HTML-код
- Опубликовано: 22 авг 2024
- A viewer asks how one can identify the location of a point in a graph in a dataset. Here I show a couple of quick options!
Excel Video Playlist 1: • Excel Videos
Excel Video Playlist 2: • Short Excel Videos: Bu...
My Website: www.burkeyacade...
Support me on Patreon! / burkeyacademy
Talk to me on my SubReddit: / burkeyacademy
Buy me a cup of coffee on PayPal? paypal.me/Burke...
Is there a way to see the location of a part of the graph that has no data point? Often times I want to find the distance between a data point and a place that doesn't have a data point.
How do I make it so the labels I select in the cells as you did only show up when my cursor rolls over the data point? I have a scatter plot with a lot of points and I only want to see the label when I roll over that specific point similar to how you showed the coordinates show up on the roll over but I want to see my label instead.
Thank you this is EXACTLY what I was looking for. Problem solved!
THANK YOU. Only video I could find that leads me to the RIGHT answer. Appreciated.
Saved me a lot of time...thanks
Thank you this is EXACTLY what I was looking for. Perfect Video !!!
There is no option for " value from cells" on my excel. Are they just different versions? Or was this option removed?
Me too
Thank you so much. You saved my day. 😉👍👍
great work...great thinking...appreciate your way in solve problems ..thanks sir
Very useful! Thank you!
Hello! How can I change the name of the point without having to show a data label? For example, when I hover over point 3, the little textbox will read out "1" as the name of the point?
It solved my problem. Thanks!
How can I identify a point with same data? for example ID 6 en 7 have the same data and is shown as one point. I would like the point shows ID 6 and 7
This is really helpful thanks a lot
great help. I need to make some of my id-data labels a different color and smaller font. and i want to remove the blue dot and only have the data label. thanks
I've got loads of data entries which makes it difficult for me to label the data point as it will just be a massive mess of writing bunched together to make one large black circle in my graph. Is there a way for me to change the point name when I hover over it so that I can see the name of any outliers without having to give it a visible label name?
Hi Sir,
Thank you for the great video!
What if I want to see the ID only if I click on a determined point?
Thank you
I am not sure how one would od that in Excel. Here is a solution using checkboxes. ruclips.net/video/0B8NdIjpaX4/видео.html
God bless you!
This is awesome. Is it possible to show data values in tooltip? i.e ID value
Thank you, just what I needed!
very good trick,
thank you!!
THANK YOU SO MUCH!
hi if i want to see the id only when the curser is on the dot ?
I don't know of a way except for using an Excel add-in, such as www.tushar-mehta.com/excel/software/chart_hover_label/index.html
This is unfortunately not helpful. I have a scatter plot with nearly 1,000 points in it and I need a way of selecting the specific X and Y values in the columns of data that were used to create the chart such that the specific point those two numbers create in the chart is highlighted.
Here is a new video for you, with a 1,000 row mega point selector for you, with downloadable spreadsheet. ☺ ruclips.net/video/0B8NdIjpaX4/видео.html
how to find a point in a curve that has the same value for x and y
How do you draw the lines to connect the points
I dont see optio of value from cells
hi do you have a way to calculate the shortest distance between the line of best and a point?
i know how to do this manually by putting the point into an equation with slope/1 then calculating b then using the distance formula but life is too short
Sure- by "distance" in stats we normally mean the difference between the y value predicted by the line of best fit and the actual y value- we write this as (yi-yhat). When you add trendlines you can select "add equation to chart" and use this equation to calculate the yhat (predicted value) for each observation of X, and calculate the difference.