Tables with datasheets

Open a table's datasheet

To insert and place a table on your slide, choose  Table from the Elements menu. All tables in think-cell are data-driven, so they have the same internal datasheet as think-cell charts. It is opened automatically after you insert a table:

To open the datasheet again later, double-click any table cell.

Whenever you change or add data, your think-cell table will reflect this. You do not need to manually add additional columns or rows.

In the same way, you can simply delete cells, rows or columns from the datasheet to remove them from the table.

Match table formatting to Excel

Match specific formatting options in your think-cell table to your Excel table, or recreate your entire Excel table and its formatting in your presentation.

• Match element formatting to the linked data range
• Insert tables with Excel formatting
• Insert images of tables

Duplicate chart data as a table

With an Excel sheet or a slide datasheet, use the same data to create both a chart and a table below the chart. The chart's series labels are also the table's column headers. To create a table with data that you can move between the chart and the table, see Charts with data tables.

To add a chart's data as a table below the chart, follow these steps:

1. From Excel or the slide datasheet, create your chart (see Create charts from Excel or Slide workbooks).
2. In the sheet, select the chart data, leaving out the category labels.
3. On the ribbon, on the Insert tab, select Link to PowerPoint > Table with Formatting.

4. In PowerPoint, insert your table below the chart.
5. Align the table columns with the chart's category labels (see think-cell alignment guides).

6. Format the cell contents as needed (see Format tables).

Add Harvey balls, checkboxes, and images to tables

Instead of text, table cells can also contain Harvey balls, checkboxes, and images. You can control these elements' states dynamically in the table's datasheet or linked range in Excel.

To display a Harvey ball, checkbox, or image in a table cell, select the cell to open its mini toolbar, then choose one of the following:

• Harvey Ball
• Checkbox
• Picture from Online Service

In the datasheet or Excel range, the cell that is linked to the element must contain the following:

• Harvey ball: A number between 0 and the maximum number of segments (by default, 4), indicating how many segments should be filled.
• Checkbox
  • To display a check: v, o, or 1
  • To display an X mark: x or 2
  • To display an unchecked box: Space or 0
• Image: The image's URL. To obtain the URL, in your browser, right-click the image and select Copy Image Link or Copy Image Address.

If the linked cell doesn't contain the required content—for example, if the cell is linked to a Harvey ball and contains text—a red exclamation mark appears next to the cell, with a tooltip that explains the error.

Additional resources

• Harvey balls and checkboxes
• Resize, crop, and align images