scatter

  1. M

    How do I get a label in a scatter plot instead of "Series 1 Point"?

    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...
  2. S

    Scatter Plot X,Y Coordinate Number of Occurrences

    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...
  3. S

    scatter with movement tracking

    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...
  4. M

    Scatter chart. Change Horizontal Axis Labels

    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...
  5. r1998

    Combined Chart ( Line Chart and XY Scatter Chart ) Problem

    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...
  6. F

    Creating a scatter chart

    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...
  7. C

    Scatter chart won't consider new data input?

    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!
  8. R

    XY Scatter Plot: drawing ines connection data points

    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).
  9. J

    Open Associated Links via Scatter Chart

    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...
  10. S

    Scatter Chart, Legend issues

    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...
  11. S

    Tables and X Y Scatter Charts

    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...
  12. C

    Scatterplot treats letters as 0 numbers, how to prevent that?

    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?
  13. S

    Scatter Plot question

    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
  14. V

    All the data labels on Scatter graphs are not visible

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

    Adapting VBA script for multiple series

    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!
  16. V

    Scatter Graph Markers - VBA

    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...
  17. D

    XY (Scatter) Chart Question | Key Events for Project 1.1

    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...
  18. D

    xy scatter with picable dates

    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
  19. A

    Scatterchart with weight with self-defined values for x and y axes

    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...
  20. R

    Chart which shows frequency of each pair

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top