Quickly break link between chart and data with one click in Excel
Kutools for 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).
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.