In our example, we want to add a third data series.
Double-click the chart to switch to the linked data range in Excel.
Simply click the menu in Excel’s think-cell toolbar and click on the chart in Power Point that you wish to link to.
Transposing a data range swaps the chart’s row and column data interpretation, letting you, for example, create column charts from rows rather than columns of data.
The most important function of a chart that is linked to an Excel workbook is the option to update the chart according to changes in the underlying data.
Switch to the slide where you want to insert the chart, or insert a new slide, and place the chart as usual: Click once to accept the default size or click, hold and drag to change the chart’s initial size.
For a detailed description on how to place, resize and align a new chart, please refer to Inserting a new chart.
Enter the additional data below the linked range: Then, select the linked range by clicking on its border to show the familiar think-cell user interface.
Drag a corner of the selection to include the newly entered data: Finally, return to Power Point.
When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.
When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.
The NOW function takes no arguments; it is entered with empty parentheses.
When you enter the NOW function in a cell, it will display the current date and time.
Thus, you always have the option to update the chart later.