27.7.3.2 The (Options) Excel Tab

Excel1.png

Plotting Selection Group

Default Plot Assignments

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.

Scan data for legend

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.

Plot Into

When selecting multiple data sets for plotting, control the display of the data plots from this drop-down list.

  • Select Single Layer to plot the selected data sets into a single layer in a graph window.
  • Select Multiple Layers to plot each selected data set into its own layer. All layers display in the same graph window.
  • Select Multiple Pages to plot each selected data set into its own layer. Each layer displays in its own graph window.

Prompt Before Group

Opening Excel files during drag and drop

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.

Saving Excel workbooks

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.

  • Select Never to prevent Origin from opening the Save Excel Workbooks dialog box under all circumstances. By default, external Excel workbooks are automatically updated when the project that includes this Excel workbook is saved.
  • Select Before saving to direct Origin to open the Save Excel Workbooks dialog box whenever you select File: Save Project (or whenever you click the Save button on the Standard toolbar), assuming the project includes an Excel workbook. The Save Excel Workbooks dialog box allows users to determine which (external) Excel workbook files to update when the project is saved. By default, all external Excel workbooks are updated.
  • Select Before Saving Project As to direct Origin to open the Save Excel Workbooks dialog box whenever you select File: Save Project As..., assuming the project includes an Excel workbook. (See the Before saving option.)