Charts with data tables

Create think-cell charts with data tables that let you choose whether to represent data graphically or in tabular form. Move rows and columns of data between the chart and the data table using the chart's context menu or the element datasheet toolbar.

Enable charts with data tables

To enable charts with data tables, on the PowerPoint ribbon, select Insert > think-cell > Tools > Enable Data Tables for New Charts . You can use the following think-cell chart types with a data table:

• Column and bar charts
• Line and profile charts
• Combination charts
• Area charts
• Waterfall charts
• Mekko charts

When you insert a chart with a data table, think-cell automatically groups the table and the chart, and adjusts the size and position of the table based on the chart's size and position. You can style a chart's data table just like any other think-cell table (see Format tables). You can also move and resize the table independently from the chart. To do so, ungroup the table and the chart before moving or resizing the table (see Ungroup objects).

Move data between the chart and the table

You can move data between the chart and the chart's data table using the chart's context menu or the toolbar in the chart's datasheet.

Move data using the context menu

To move data from the chart to the table using the context menu, follow these steps:

1. Right-click the segment, line, area, or label that represents the series or category that you want to move. The context menu opens.
2. On the context menu, select where you want to move the data:
   • To move a series to a table row, select Move Series to Table .
   • To move a category to a table column, select Move Categories to Table .

To move data from the table to the chart using the context menu, follow these steps:

1. Right-click anywhere on the table row or table column that contains the data you want to move. The context menu opens.
2. On the context menu, select where you want to move the data:
   • To move a series to the chart, select Move Series to Chart .
   • To move a category to the chart, select Move Categories to Chart .

Move data using the datasheet toolbar

To move data using the chart's datasheet toolbar, follow these steps:

1. Open the datasheet by double-clicking the chart. Alternatively, select the chart, then select Open Datasheet .
2. On the datasheet, select a cell, a row, or a column, then select where you want to move the data in your selection:
   • To move the series in your selection to the table, select Move Series to Table .
   • To move the categories in your selection to the table, select Move Categories to Table .
   • To move the series in your selection to the chart, select Move Series to Chart .
   • To move the categories in your selection to the chart, select Move Categories to Chart .