2

There is a certain chart in Excel that I cannot exactly replicate in Word, so I copied the chart into a Word document. However, now the chart's data are tied to the Excel document I copied the chart from. I'd like to separate the data from the Excel file so the chart's data is stored in the same way it would be stored if I had created a chart in Word from scratch - within the Word file.

Can this be done?

Improve this question

2 Answers 2

Reset to default
1

  1. Create your chart in Excel -- it will be easier later if you have the data in one sheet and the chart in another. Make sure the sheet with the chart is visible and that the chart is in the top left corner of the sheet (again, this makes things easier later on)

  2. Save the .XLSX wherever is convenient and close it

  3. Open the Word file

  4. Drag the Excel file onto the Word document or go to Insert -> Text -> Object -> Object, then click on the "Create from File" tab, browse to your file and, making sure the "Link to File checkbox is unchecked, click OK.

  5. If you right-click on the chart, you should be able to edit it by choosing Worksheet Object -> Open in the pop-up menu

Improve this answer
0

You can unlink the Excel file, but then you cannot edit your chart data.

  1. On File menu, bottom right area (Office 2016) there's a button "Edit Links to Files".
    Edit Links to Files

  2. Choose your connection and click on "Break Link".
    Break Link

Improve this answer
4
  • Thank you for your answer, but the chart's data is going to be edited monthly, which means I cannot lose the ability to edit that data.
    – k.d
    Mar 28, 2019 at 8:45
  • In this case, IMO, it is best to keep files liked. If you separate them, there is more area for human error when trying to manually copy data to Word.
    – ZygD
    Mar 28, 2019 at 9:39
  • I forgot to mention this in my previous comment, but I'll be making copies of this file, and each time I make a copy, the link remains, so every time I'm editing a copy of this file, I'm also editing the linked spreadsheet that previous copies of the document use. This is pretty much the reason why I wanted to unlink them.
    – k.d
    Mar 29, 2019 at 7:11
  • Then this other answer may help. It kind of creates an Excel file INSIDE the Word file. So every copy of the Word file will have it's own internal embedded Excel.
    – ZygD
    Mar 29, 2019 at 8:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .