Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Plotting a Difference wave in Excel

  • 10-11-2012 05:09PM
    #1
    Smythe
    Registered Users, Registered Users 2 Posts: 434 ✭✭


    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!


Comments

  • #2
    Victor
    Registered Users, Registered Users 2 Posts: 78,804 ✭✭✭✭Victor


    Smythe wrote: »
    The first wave has quite a lot more readings which make it than the second wave.
    I think the gremlins got to this sentence. :)

    You don't give the characteristics of your lines.

    I've made line 1 and 2. Line 2 is 90 degrees out of phase and has half the wave length. Depending on the characteristics, the third wave may have a different wavelength (wavelength = 1/frequency) or indeed be flat. Pitch will always be between -1 and 1.

    You can then subtract one from the other and plot that.

    Are these the same thing:
    * differences between the sines and
    * sines of the differences?

    I've had to use Open Office, you can finesse things a bit more with Excel.

    228022.PNG


Advertisement