Excel 2016 data labels not updating

For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.This is how the example chart data looks in Excel: To create a chart from Excel, select the desired data range in your Excel workbook, including series and category labels: The layout of your data must match the layout of think-cell’s internal datasheet: Column charts are usually created from data columns, whereas bar charts are created from data rows.

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.

This option is available in the dialog (Data Links dialog).

Note: Linking a chart to data in Excel using think-cell does not depend on the file names of the Excel or Power Point file.

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.

Leave a Reply