- #1

- 3

- 0

## Main Question or Discussion Point

i have an excel file containing 2 graphs [R & V], and their x & y coordinates in 4 separate lists [the X coordinates of R, the X coordinates of V, the Y coordinates of R, the Y coordinates of V]

i need to calculate the X & Y coordinates of a 3rd graph through a weighted formula that takes 55% of the R coordinates into account + 45% of the V coordinates into account

the tricky part is that R & V start and end at different X coordinates...

for example R starts at x=0 and ends at x=10

while V starts at x=5 and ends at x=15

can anyone help define a better formula for this?

here is what i have so far:

X = (Xr+Xv)/2

Y = (Yr)*0.55 + (Yv)*0.45

the problem with these equations is they dont take into account the different start and end positions of the two graphs

thank you for any help in advance! best regards!

i need to calculate the X & Y coordinates of a 3rd graph through a weighted formula that takes 55% of the R coordinates into account + 45% of the V coordinates into account

the tricky part is that R & V start and end at different X coordinates...

for example R starts at x=0 and ends at x=10

while V starts at x=5 and ends at x=15

can anyone help define a better formula for this?

here is what i have so far:

X = (Xr+Xv)/2

Y = (Yr)*0.55 + (Yv)*0.45

the problem with these equations is they dont take into account the different start and end positions of the two graphs

thank you for any help in advance! best regards!