Top > Technical-notes > VNWA > Displays the converted Impedance data as a graph.

Displays the converted Impedance data as a graph.

Create a frequency-impedance graph of resistor using EXCEL.

Import the VNWA data of the frequency characteristics of the resistor into EXCEL.
Convert Resistor's VNWA-s1p data to impedance.

Select the Scatter with Smooth Lines for the graph.

The S11 of a 235Ω resistor was measured using a Vector Network Analyzer (VNWA3E) DG8SAQ, and the S1p data was imported into Excel. This image explains how to create a frequency response graph from the calculated impedance data. The graph to be used is selected.

Right-click the chart area and click Select Data.

This explains the steps for creating an impedance vs. frequency graph using S11 data measured on a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Select the data to use for the graph.

This explains the steps to create an impedance vs. frequency graph using S11 data measured on a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Select Add Data to Graph.

Enter the Series name and then click the Select Range arrow.

This explains the steps to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Enter a title for the graph.

A small window will appear; open the file or sheet containing the converted data,
Select all frequency data and click the arrow.

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured on a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Select the frequency data range for the graph.

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. This section explains how to set the impedance axis of the graph.

A small window will appear; open the file or sheet containing the converted data,
Select all Z data and click the arrow.

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Select the range of impedance data for the graph.

This explains the steps for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. The frequency and impedance data for the graph were set.

This explains the steps for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. All graph data settings are now complete.

Make graphs bigger and easier to edit,
and edit by right-clicking the horizontal scale axis

This explains how to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Right-click on the horizontal axis of the graph to set the scale.

Convert to logarithmic scale

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Change the horizontal axis of the graph to a logarithmic scale.

Move the holizontal scale position

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Set the horizontal scale to Low.

Edit by right-clicking the vertical scale axis
Change the maximum and minimum values of the scale.

This explains how to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Right-click on the graph's vertical axis to set the scale.

This explains the procedure for creating an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Set the maximum and minimum values for the graph's vertical axis scale.

Adds minor tick marks to the horizontal axis.

This explains the steps to create an impedance vs. frequency graph using S11 data measured on a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Right-click on the horizontal axis of the graph to add auxiliary gridlines.

Right-click on impedance data line to edit

This explains the steps to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Right-click the impedance data line to edit it.

Edit the data line of the graph

This explains how to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. You can remove the markers from the impedance data line.

This explains how to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. You can change the thickness and color of the impedance data lines.

Right-click on impedance data line to edit graph title.

This explains the steps to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. To edit the graph title, right-click the impedance data line and click Select Data.

This explains the steps to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. To edit the graph title, right-click the impedance data line and click Select Data. The Select Data Source window will appear, so click Edit.

This explains the steps to create an impedance vs. frequency graph using S11 data measured with a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. To edit the graph title, right-click the impedance data line and click Select Data. The Select Data Source window will appear, click Edit, and the Edit Series window will appear, allowing you to edit the data.

This explains the steps to create an impedance vs. frequency graph using S11 data measured on a 235Ω resistor using a Vector Network Analyzer (VNWA3E) DG8SAQ. Edit the graph title and click OK to finish.

This is an image of an impedance vs. frequency graph created in Excel using data from S11 measurements of a 235Ω resistor taken with a Vector Network Analyzer (VNWA3E) DG8SAQ.

Click here to download Create-S11ZFgraph-VNWAs1p.xlsx

© SMPS Solution