I am running into a problem where a line is extending beyond where I believe they should (see below). I want the lines to end at the orange dots yet they are extending beyond them.
The problem starts when I create a calculated field for the circles. I am using the formula if first()=0 or last()=0 then sum([T2]) end for the calculated field to create the circles.
Once I create the circles field the lines extend beyond where they are suppose to. In the data there is no line coordinates that extend beyond the final coordinates of the circle.
I am attaching the workbook since this is tough to explain without seeing the data.