Plotting a Difference wave in Excel

AI Thread Summary
To create a graph of the difference between two sinusoidal voltage waves plotted in Excel, it is essential to ensure that the data points correspond to the same time stamps. If the two waves have different sampling rates, interpolation may be necessary to align the data. Excel offers interpolation functions that can help standardize the datasets. Once the data points are matched, the difference can be calculated and plotted, allowing for a clear visualization of the variations between the two waves.
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.
 

Similar threads

Replies
1
Views
3K
Replies
3
Views
3K
Replies
4
Views
6K
Replies
0
Views
320
Replies
0
Views
786
Replies
10
Views
2K
Replies
0
Views
307
Back
Top