Options-Dialog-Excel-Tab
Check this check box to plot by highlighting the workbook data and assuming column designations appropriate to a selected graph type. If no workbook data is highlighted when the graph type is selected, Origin opens the Select Data for Plotting dialog box.
Check this check box to create a graph legend by automatically searching the associated workbook for text. For each data plot, Origin begins searching for legend text in the cell immediately above the cell that contains the first Y data values. Origin continues to search upward in the column until it finds text values.
When selecting multiple data sets for plotting, control the display of the data plots from this drop-down list.
Check this check box to show a dialog box that allows users to choose how an Excel file is opened in Origin when the file is dragged and dropped into Origin. If “Yes” is chosen in the dialog, the Excel file will be imported into an Origin workbook. When “No” is chosen, the Excel file will be opened as an Excel workbook inside Origin.
When this check box is unchecked, Origin always opens the Excel file as an Origin workbook.
This drop-down list controls the display of a dialog box that determines how internal and external Excel workbooks are saved when you save a project that contains the workbook.