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

X,Y,Label command

Print this Topic Previous pageReturn to chapter overviewNext page

Creates one curve with optional labels at one or more data points.

X is taken from the first selected column, Y from the second selected column, and labels from the third selected column. If your columns are not in X,Y,label order, you can make multiple selections by use of the Ctrl key. Select the X data first, press Ctrl and select the Y data, then press Ctrl and select the labels. Each selection should begin in the same row.

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.

Label placeholders

To embed the amplitude of a data point in a label, type $Y in the Label field. To embed the abscissa of a data point in a label, type $X. When the label is drawn the corresponding numeric values will be substituted for these control codes. For example, a label of "$X sec, $Y psi" at the point (5.5,100) will appear as "5.5 sec, 100 psi".

Initial plot settings

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:


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


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.



Page url: