Link to an Excel Chart

1.   In an Excel worksheet, select a desired chart you want to copy and then press command + C to copy the selected chart

 

 

2.   In the Word document, select the place where you want to place the Excel chart and press command + V to paste the copied chart

NOTE    Office will create a live link between the original chart with its data and the copy of the chart. Therefore, any changes in data values associated with the chart in the original Excel worksheet will update to the copied chart pasted into Office documents



3.   To remove a live link between the two charts, do the following:

  • In Word document, click the Paste Option button
  • Select  one of the below paste option from the shortcut menu
    • Paste as Picture – insert a copy of Excel chart as an image without connecting to the original chart
    • Excel Chart (entire workbook) – create a copy of the entire workbook and embedded it in the destination document