Plotting a Difference wave in Excel

Smythe

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!

citrus burst

What do you want to graph? The amplitude? or the phase shift?

Smythe

citrus burst wrote: »

What do you want to graph? The amplitude? or the phase shift?

I want to plot the difference between the two waves (i.e. the residuals of these) against time.

One wave is a measured wave based upon actual measurements, the other is the theoretical wave if everything in the experiment was 100% perfect.
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman][/FONT][/FONT]

Gurgle

If you've got measured data in column A and ideal data in Column B, then you just need a formula in column C where Cn = An - Bn

Donne

Just to but in have you ever heard of Gnuplot.
You can run it in Windows, though it was ororgiinally developed in Unix/Linux.

It's the standard for science/engineering graph plots.

Victor

Ooops, I meant to respond to this last month.

Obviously your data will be different from mine.