i get what your saying in only using values for the common interval between both graphs
but I am supposed to somehow use weighted averages to weight the data points as well as the difference between the intervals. fairly complicated ugh
thank you btw!
to clarify:
imagine graph A starting at Jan 1 [point M] and ending at Jan 20 [point N]
imagine graph B starting at Jan 10 [point O] and ending at Jan 31 [point P]
i want to generate a set of points that take on a weighted average of the points from graphs A & B but also starts at point M...
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%...