Updating links between excel and powerpoint
Nevertheless it is possible to transpose the data source (see Transposing linked data).In addition to the data, some cells to the left and on top are reserved for category and series labels.Thus, you always have the option to update the chart later.You can also let think-cell automatically update the linked chart for you.After insertion, the chart looks and behaves like a regular think-cell chart that has been created in Power Point: Please refer to Adding and removing labels and Styling the chart to learn how to configure and style the chart.Note: If you use colored cell backgrounds in Excel, you can set those as the segment fill color in the linked chart by enabling in the chart’s color scheme control (see Color scheme).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.
In Power Point, when the mouse pointer is on a slide, the familiar insertion rectangle appears.
If you are unsure about the exact layout required, simply insert a new chart of the desired type in Power Point and refer to the layout of its datasheet.
Then select the desired chart type from the menu in Excel’s think-cell toolbar: When you click on this menu item in Excel, the Power Point window is activated.
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.