Quickly break link between chart and data with one click in Excel

Normally, when creating a chart, the source data will be linked with the chart automatically as below first screenshot shown, if you copy and paste the chart to another workbook, when opening the other workbook that will bring up a dialog box asking whether you want to update the links, the chart may get messed up. In this case, you can break the link between chart and source data firstly, and then copy and paste the chart to anywhere you like.

To break the link between chart and original data, Kutools for Excel’s Detach Chart can help to convert the referenced data in the chart to actual values for delinking the chart as the second screenshot shown with only one click.

Normal chart with linked source data

Delinked chart with actual values

After installing Kutools for Excel, to break link between chart and source data, please do as this:

1. Click to select the chart that you want to break links with the source data, and then click Kutools > Charts > Chart Tools > Detach Chart, see screenshot:

2. And then, a prompt box is popped out, click OK, now, the link between the chart and source data has been delinked at once, see screenshot:

Note: If you want to recover the link, this feature supports Undo (Ctrl + Z).