Quickly break link between chart and data with one click in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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).
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
