scatter

I've got a scatter plot and when I hover over a point, it says something like: Series 1 Point "1.03" (1.03, 4.12) Series 1 Point "2.7" (2.7, 3.06) I'd prefer for it to say: Thomas (1.03, 4.12) Leslie (2.7, 3.06) I can get the labels onto the chart, the problem is when hovering the mouse...

I am looking to build a scatter plot to illustrate how many times an X,Y coordinate appears. So, if I have 15 occurrences of 2,3 then I would like to see 15 points at 2,3 on my chart. If I have 3 occurrences of 2,1 XY corrdinate, I want to see 3 points right there. I need this to be a scatter...

Hi all I'd like to build a scatter graph with a slight difference. In the source data there are 2 variables for each person, and both can shift in either direction (up or down). Normally we plot a single point for each person on a scatter and just have different scatters for different data...

Hi everyone, Hope this question hasn't been asked before, if so apologies. I'm working on a scatter chart but having trouble with the X-axis labels. I want to have sequential dates running along the bottom of the X-axis, but no matter what I do it's labelled with even-numbers. I'm using a...

Dear Friends and Respected Seniors, I have a chart containing a Line Chart Series and an XY Scatter Chart Series. Data for Line Chart is from A1-B9 and data for XY Scatter Chart is from A11-B19. Data from A1-B19 is <tbody> Line Data 1 #N/A 2 84 3 55.7 4 67.5 5...

Hi everyone! I'm stuck trying to create a custom scatter chart. I have the following columns: <tbody> Name Angle n0 Value Angle n1 Value Angle n2 Value Frank 5 12 12 22 23 40 Peter 7 15 17 33 28 38 </tbody> I need a chart with Angles (n0, n1 and n2) in the x-axis and Values in the...

Hi, I added some additional rows with information but my scatter chart does not update accordingly even though selected data includes those rows as well. Anyone who can advice? Thanks!

I have followed MS explanatory to no avail. I have created a Scatter diagram showing smoothed lines thru the data points with the highlighted data points in my spread sheet.. However, lines do not appear. Thank you id advance for your suggestion(s).

I have a four columns in my data set. They are: File Name, X, Y, and a URL link column. <tbody> File Name X_value Y_value URL File1 2 9 url.com/file1 File2 1 7 url.com/file2 File3 8 3 url.com/file3 </tbody> After creating a scatter plot of the X/Y values; I would like to be able to...

Hi, I have a file with a table that I have also created a graph to go with. When I created the chart, it looked great, but as I filter the data the legend changes. It will go from markers (which is what I want to show) to lines or just not have a marker or a line. Is there a way to set the...

I need some help! I am usually very fluent in all thingsExcel but this has me stumped. I have a table with over 1350 rows of data. I amtrying to create an XY scatter chart. This table has 6 sets of data for the Yand 6 sets of data for the X axis. Y is the power and X is the flow (seebelow). I...

I have same data points from equation =IFERROR(K3+Q3;""). When I plot these numbers and "" blanks into scatter plot, "" blanks are treated as 0 numbers. Is there any way to prevent that?

I am creating a scatter plot in excel with over 180 points. With that many points I am not able to use data labels to show which point is for what item. Is there a way that I can change the y variable within the data point to point to the item of the y axis? Thank you

Guys- i have created a scatter graph and for someof the data labels arent visible? could see the image attached for further details. thanks

Hello, Should be an easy one. Struggling to adapt this macro for multiple vba scripts: https://support.microsoft.com/en-gb/help/213750/how-to-use-a-macro-to-add-labels-to-data-points-in-an-xy-scatter-chart Any ideas and what data form it should be in? Cheers in advance!

Hello All, Been struggling trying to adapt my working VBA to a user friendly one. I have data in the form: | X. |. Y. | A. |. 1. |. 2. | B. |. 2. |. 3. | C. |. 3. |. 3. | With A, B, and C with different conditional formatting...

Hello Mr. Excel Masters! I create a chart to visualize "Key Events for a Project" based in a XY (Scatter) Chart. There is a way that Horizontal Axis reflect the dates entered for the chart? I mean, Each milestone date show on the axis instead of a range of time? Link to Template download...

All, I have an xy scatter with dates up to a year with minute data. I want it in an xy scatter but I want to be able to pick a date range without editing the axis. Any help would be great. thanks

Hi all, I have this data: <tbody> label x y weight a -1 3 1 b -10 -3 1 c -7 8 3 d 1 -2 2 e -8 -4 5 f 8 7 3 g -9 8 6 h 6 5 4 i 2 -3 8 j 2 -2 5 </tbody> And I want this result: The weight is optional. The labels are not optional. What's the best way to approach this? A...

I have a data set, part of which looks as follows: <colgroup><col span="2" style="text-align: center;"></colgroup><tbody> X-axis Y-axis 50 50 50 100 50 100 100 50 100 100 250 100 250 250 250 250 500 100 </tbody> <tbody> 500 250 </tbody> <tbody> ... </tbody> Because I...