The chart is not highlighted or flagged, but you still have the option to manually revert the automatic update.
Change detection works only while both files, Excel and Power Point, are open at the same time.
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.
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.
This ensures that any changes made using the internal datasheet are not automatically overwritten when the linked Excel file becomes available.
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.
When selecting the linked chart, it is flagged to indicate that an update of its linked data has been detected: Click the button.
Even if the chart is not updated, or is updated and then reverted again, the link to the Excel data source remains.