Show All

Link chart data labels to worksheet cells

If you have changed the data label text on a chart, the data label is no longer linked to a worksheet cell.

1. Click a data marker in the data series associated with the data labels whose links you want to reestablish.
2. On the Format menu, click Selected Data Series, and then click the Data Labels tab.
3. Select the Automatic text check box.

Note  In PivotChart reports, this procedure reestablishes links between data labels and source data (not worksheet cells).

To reestablish links between data labels and worksheet cells for all data series in the chart

1. Click the chart, and then click Chart Options on the Chart menu.
2. On the Data Labels tab, select the Automatic text check box.