Plotting a Difference wave in Excel

Click For Summary
SUMMARY

The discussion focuses on plotting the difference between two sinusoidal voltage waves in Excel. The user seeks guidance on creating a new graph that represents the difference between these two waves, which are plotted against time. Key advice includes ensuring that the difference is calculated using terms with equal timestamps, potentially requiring interpolation. Excel's built-in interpolation functions can facilitate this process, allowing for the standardization of datasets before subtraction.

PREREQUISITES
  • Basic understanding of Excel graphing tools
  • Familiarity with sinusoidal wave characteristics
  • Knowledge of data interpolation techniques
  • Experience with time-series data analysis
NEXT STEPS
  • Explore Excel's interpolation functions for data manipulation
  • Learn how to standardize datasets in Excel
  • Research methods for calculating differences between time-series data
  • Investigate advanced graphing techniques in Excel for visualizing differences
USEFUL FOR

This discussion is beneficial for data analysts, electrical engineers, and anyone involved in visualizing and comparing time-series data in Excel.

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

MATLAB MATLAB: Plot Contour at 0km Depth
  • · Replies 1 ·
Replies
1
Views
3K
How to Plot Multiple Data Series on a Single Excel Scatter Plot?
  • · Replies 3 ·
Replies
3
Views
2K
MATLAB MATLAB API For Wave Flume Data Analysis
  • · Replies 3 ·
Replies
3
Views
3K
Graphing the Superposition of Two Standing Waves
  • · Replies 8 ·
Replies
8
Views
2K
MATLAB Excel date column export into Matlab
  • · Replies 4 ·
Replies
4
Views
6K
Java Processing - Plotting Two Curves on the same Plot
  • · Replies 1 ·
Replies
1
Views
1K
How could I plot my data? (which software)
  • · Replies 2 ·
Replies
2
Views
3K
Java Kotlin --> Plotting Two Curves on the Same Plot
  • · Replies 1 ·
Replies
1
Views
2K
Graphing Elastic Potential Energy
  • · Replies 10 ·
Replies
10
Views
2K
Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K