AMU Header

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 interpolated.

This makes the measured points visible by drawing lines between the few points.

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.

In the plot shown below, once the measured data trace was visible it was