Navigation:  Transferring data > Using the DPlot Interface Add-In for Microsoft Excel >

XYXY Add-In command

Print this Topic Previous pageReturn to chapter overviewNext page

Select alternating X,Y columns and produce an XY plot. Column selections may have differing numbers of rows.

You may use multiple selections (by use of the Ctrl key). The first column selected is taken to be the X axis values for the first curve; the second column selected is used for the Y values of the first curve, etc. So if, for example, your data is arranged with Y values in column A and X values in column B, you should first select column B, then use the Ctrl key to append column A to the selection.

If the data (including column headings, if any) you'd like to plot begins in row 1, you can select entire columns by clicking on the column headings (A, B, C, etc.). The XYXY function assumes that data for any curve stops at the first blank X cell.

Initial plot settings

Symbols and lines

Intially, XY plots produced by the Add-In will consist of line segments between each data point, with no symbols. You can easily switch to a scatter plot by:

1)

Select Scatter Plot on the Options menu. For any curves that do not have a symbol selected, filled circles are used. Line type is set to "None". Or

2)

Right-click on a curve, select "Symbol style", then repeat for the "Line style", setting the style to "None". Repeat for all curves.

If you are working with more than a couple of curves you may prefer to use the Symbol/Line Styles command on the Options menu.

Scaling (linear, logarithmic, polar, etc.)

Initially, XY plots generated by the Add-In will use linear scaling on both the X and Y axes. To change to a different format (logarithmic scaling, polar plot, etc.), right-click on the plot and select the scaling you'd prefer.

Example:

 


Page url: https://www.dplot.com/help/index.htm?xyxycommand.htm