help please; i've created a spreadsheet that generates start, stop times, (x1, x2) and the data value (Y). now i'd like to plot. ie
point 1 start 0, finish 3; value 5
point 2 start 1, finish 5, value 2
so that at 0 the value is 5, at 2 the value will be 7 (point 1 value plus point 2 value), at 4 the value is 2
ideas on how to use excel formulas to accomplish; or VBA routines i could download ??
thanks
Bookmarks