4.7 Inserting Graphs Images and Other Objects into Worksheet Cells

Video Image.png See more related video:Insert Graphs

Origin worksheets can be a container for various types of information, beyond the usual tabulated text & numeric data. For instance:


This topic is concerned only with those things that can be inserted into worksheet cells, either in the header rows or data rows.

Inserting Graphs, Images and Other Objects into Worksheet Cells-1.png

The following table lists things that can be inserted into worksheet cells. Some elements can be inserted into either header rows or data rows (indicated by the availability of the shortcut or menu command).

Linking Origin worksheet cell contents to variable values, to values in other Origin workbook cells or to other graph windows, can all be useful in automating routine tasks and generating reports.

Element Comments

Arrow

Useful for annotating worksheets.

  1. Right-click on the cell and choose Insert Arrow > type.

Graph as Editable Graph†

This embeds an editable graph in the worksheet cell. Edit the graph by double-clicking on the worksheet cell. When you have finished, click the Close button Close embed graph.png in the upper-right corner of the edited graph window. This closes the graph window and saves your changes to the embedded graph.

  1. Right-click on the cell and choose Insert Graph....
  2. In the insertGraph dialog box that opens, select your graph using the Graph Browser and click OK.
  3. Enable Move Graph to cell (Embedding) (Options branch) and click OK.

Graph as Picture†

This inserts a graph as a picture object. You can link the picture to the source graph so that any change to the source graph updates the picture.

  1. Right-click on the graph and choose Copy Graph as Picture/Copy Page, or click Edit: Copy Graph as Picture/Edit: Copy Page from the main menu.
  2. Right-click in the worksheet cell and choose Paste Link or click on the cell, then click Edit: Paste Link from the main menu. To paste a static (unlinked) picture, simply choose Paste.

You can mouse over the cell to see a preview.

Hyperlinks

You can insert hyperlinks into worksheet cells. For more information, see Inserting Links into Worksheet Cells.

Image from File†

Inserts an image (.JPG, .BMP, .GIF, etc.). Double-clicking on the image opens the image in a matrix window, in image mode.

  1. Right-click on the cell and choose Insert Images from Files....

Long Names,
Units,
Comments,
Parameter Values,
Column Forumlas, etc.

The header rows can display a wide variety of sheet and column-related data. For more information, see Displaying Supporting Data in Worksheet Header Rows.

Notes

The inserted note has the qualities of a Notes window except that the note is embedded. Double-clicking on the cell opens the note in a Notes window where it can be edited and re-embedded.

  1. Right-click on the cell and choose Insert Notes.

Sparklines†

A sparkline provides a thumbnail plot of the data contained in a worksheet column.

  1. Right-click in a Sparklines header row cell and choose Add or Update Sparklines. This adds a sparkline plot of column data to the header row cell. For more information, see the sparklines X-Function.
  1. Right-click in any data row cell and choose Insert Sparklines. This adds a sparkline plot of any dataset in the project, to the data row cell. For more information, see the insertSparklines X-Function.

Variables

You can insert variables stored in the worksheet's binary storage area (as might result from importing data files with important header information) into a worksheet cell, either as static values or as a linked value. When inserted as a linked value, a cell value is updated as the value of the linked variable changes (as might result from importing a new data file).

For more information, see The Insert Variables Dialog Box for Worksheets.

†Note: Beginning with Origin 2018, any inserted graph, whether it be a an editable graph, a graph inserted as a linked or static picture, an image inserted from file, or a sparkline, will generate a pop-up preview when you hover on the containing cell.

Embed graph preview hover.png
Topics covered in this section: