Phy 415 Electronics

Plotting Data in Excel

Measured data as well as simulated data can be plotted on the same chart using excel. Select the columns to be plotted (measured as well as simulated). In the tools pulldown menu select;

tools>Options>chart>Plot empty cells as intrepolated.

Now that the measured data is visible, it can be selected. To show data point markers, right click on the measured data trace > Format Data Series > Marker >Custom.

Choose a marker to make data points visible.