Chart data:
....................Point Blank..........Optimal.................Falloff...................2xFalloff
(X)Range Km.......0......................55.......................93.........................131
(Y)% Chance......0.723913238......0.723913238........0.361956619............0
Ok so i will always have a flat line and from optimal to 2xFalloff but there is just a point in the middle called Falloff marking out the half chance.
Now what i want to do is have an x value that no matter what the chart just stops graphing that one line at X because the data above is just one of 4 lines in the graph
the graph has to keep the y range of 0%-100% and an X range of 0km-249km
so I'm really just trying to end each individual lines X value at a certain point before 2xfalloff
will i have to make a formula to calculate where in the line it would be and have a check that checks to see if it would even be in the line?
For Example:
to the graph above i would like to have a forumla so that if i enter 97.75km in a box it ends the cirten line there that would be a little past falloff (the half way point)
The chart type is Scatter with straight lines
Bookmarks