Navigation:  Getting Started > Getting Started with XY Plots >

Getting Started with XY Plots - Data From Another Program

Print this Topic Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Items

Four methods are available for importing data into XY plots from other Windows applications.

The DPlot Interface Add-In for Microsoft Excel

This feature is of course only applicable if the source of your data is a Microsoft Excel worksheet. In general this method is superior to those described below. For more detailed information on Add-In commands see the Help command on the DPlot menu in Excel. For best results study the example spreadsheet <My Documents>\DPlot\examples.xls.

The XYXY command works with alternating X,Y columns

The XYYY command is similar to the XYXY command, but X is taken from the first selected column and all subsequently-selected columns are Y values for separate curves.

The X,Y,Label command creates one curve on an XY plot with X taken from the first selected column, Y taken from the second, and optional text labels in the third.

The Bar chart command creates a bar chart with non-numeric labels on the X axis and one or more groups of amplitudes.

The Bar chart, data in rows commands is identical, but works with data sets in the same row rather than the same column.

The Paste command (Edit menu)

The Paste command is the method most likely to be supported by another Windows application. Once data is pasted from another application, DPlot owns the data. Changes to the data in the source application are not reflected in the DPlot document.

The Paste Special Link option (Edit menu)

The Link option establishes a link with the source of the data. Changes to the data made in the source application are reflected in the linked document. Unlike the Insert Link command, this method requires switching to the source application and back to DPlot.

The Insert Link command (Edit menu)

The Insert Link command performs roughly the same function as the Link option, except that it does not require switching to the source application to initiate the action.



The default scaling for any new XY plot is linear X, linear Y. You can change the scaling (logarithmic X and/or Y, probability scale, polar chart, bar chart, ternary plot, etc.) by right-clicking within the box surrounding the plot and selecting the scaling option from the drop-down menu. Scaling options are also accessible via the Linear/Log Scaling command on the Options menu.

Symbols/Line Types

To change the symbol type or line type used by a curve, right-click on the curve and select the appropriate symbol and/or line type. Alternatively, select the Symbol/Line Styles command on the Options menu.

Scale Extents, Tick Marks, Plot Size

To change the extents of the X or Y axis, change the tick mark interval used, or to change the physical size of the plot, select Options>Extents/Intervals /Size.

Number Format

To change the number format used on any axis (to dates, date and time groups, multiples of PI, powers of 10, etc.), right-click on any of those numbers and select the appropriate format. To specify that a 1000 separator should be used, to specify the number of decimal places used, or to change the orientation of those numbers, right-click on any of those numbers and select “More number format options...”. Alternatively select the Number Formats command on the Options menu.



Page url: