Plotting a Difference wave in Excel

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
1 reply · 2K views
ZedCar
Messages
353
Reaction score
1
I have plotted two approximately sinusoidal waves in one Excel graph. Both waves are voltage, on the y-axis, against time the x-axis. Though both waves are not identical, being out of sync a little.


The first wave has quite a lot more readings which make it than the second wave.


If I want to produce another Excel graph depicting a wave of the difference in these two, how would I do that?


Thanks for any advice!
 
Physics news on Phys.org
You have a graph of v(t) vs t and i(t) vs t?

To be meaningful, you need to take the difference between terms with equal time-stamps.
This will usually mean doing some interpolation - though, if the two graphs share a lot of the same times, you may get away with just plotting the differences of the times they have in common.

iirc excell has interpolation functions - so it is probably easiest to just standardize the two data-sets and subtract them.