XY SCATTER PLOT EXCEL FREE

Please feel free to change, add, amend the workbook. Why I do not know.Īny help would be great in helping me achieve this last project. Well for some reason and why I do not know, if you click one of the points that has a reference not only to my tables below the chart but also in the 'Distance Calculations from Point to Point table 'this word appears in both charts then the workbook will not snap down or highlight, it will just put a border around the word in the Distance Calculations from Point to Point table.

If you click on a point on my chart you will see that the workbook snaps down to the name and highlights it. Any thought and changes to this workbook are welcomed.Īlso there is a PROBLEM with one of my macros I can't seam to find and it is this. How do I get the get category for the point 'A' /'B' to show up in the Distance Calculations from Point to Point table?Ĭan this be done by Macros or a combination of both Macros and formulas?Īll data for the chart comes from the data workbook, play with it and you will see how I have laid it out to work. So how do I calculate the distance now between these 2 points? Does there have to be a 'Z' axis incorporated for the calculations to happen? If we start from the origin of x=0, y=0 then we would divide the overall distances in half bars are just a different representation of the same logic). Viewed 901 times -2 I am trying to plot some comparative data in excel, but all the available graphs appear to be variants on basic lines (e.g. The size of my (x, y) scatter plot in FEET are these dimensions Ask Question Asked 6 years, 3 months ago. These 'Point 'A' and Point 'B' refer to the numbers on my cart and I want to calculate the distance between these too points in feet and also display what these 2 points 'A' and 'B' are in my 'Category of Point 'A' / 'B'. I have a few examples I typed in to this table for you too see what I want to do. If you look at the chart in the (B_D sec 9) workbook you will see the chart as well as my 'Distance Calculations from (Point TO Point) table. It is finding out the distance between (2) points on my (x, y) scatter plot chart. I would like some help in trying to achieve this last project for my workbook.

Xy scatter plot excel