How can I break external links in PowerPoint 2007 but keep the charts editable (not images)?
I have created a few charts in an Excel file and then pasted them as links into PowerPoint (PPT). Whenever I update the excel file, PPT updates automatically.
However when I break the links, the charts in PowerPoint become images. I need the charts to be normal charts which are editable. I need to send the PowerPoint to someone else but I don't want to give them the linked Excel file. Also, I need them to be able to edit the charts.
1 Answer
Charts are just a form of representation of the values. If you want to be able to edit chart you need to provide a values in a second spreadsheet. You do not have to give an additional excel file - just copy the necessary values to second spreadsheet and point the chart link to use this newly added values. It will work the same as from external file.
there is no way of keeping the chart without values that created it while still being able to edit it.
1
