Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

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.

share|improve this answer
    
Thanks for the reply but that actually doesn't solve my problem. I don't mind if the data for each chart is in individual spreadsheets (as they normally are if you create the chart in ppt). However, I don't want to have all the charts in one spreadsheet that links to ppt. Is there a way that once I break the links I can make the charts stay as individual charts (linking to separate datasheets) rather than images? Thanks –  John Dover Jul 27 '12 at 13:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.