Skip to main content

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

Author: Xiaoyang Last Modified: 2021-01-26

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
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 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations