#1
|
|||
|
|||
Extracting data from ppt graphs without linked spreadsheet
hi all,
So I've been given a fairly graph and data heavy .ppt, all of which was linked from an external spreadsheet which, alas, is now no more. The problem: As the data is no more, I appear only able to save the graphs as pictures (dooming them to a dodgy background), or have them in a semi-editable form that then complains the linked data can't be found. What I'm after... One of two outcomes would be great. - If I can get the graphs back into a fully mutable format (colour changes and re-labled) that'd be ace! - Similarly, if I could actually get the stored data out of them that'd be even better!Now the data must surely be in there somewhere, or how is powerpoint drawing the graphs I see. I'd appreciate any ideas, be those that involve the simple button i'm probably simply overlooking or some clever hackery to dig out my data! Many thanks in advance! aBoL |
#2
|
|||
|
|||
Pretty sure if the linked Excel file has gone you are just left with a screen image of the original (No Data)
|
#3
|
|||
|
|||
You should be able to cut the chart, and Paste Special, paste as an enhanced metafile. It won't be an editable chart anymore, but it will be native PPT shapes instead of a picture (you will need to ungroup the chart after pasting to convert it to shapes)
You won't be able to edit it as a chart by entering the data tables, but it will be vector shapes which would be much better than a bitmap picture. And, you will be able to edit/delete individual shapes if necessary. |
Tags |
graphs, linked data, unlink |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Doing a linked paste within a linked spreadsheet | tkondaks | Word | 1 | 08-17-2012 12:23 AM |
Display history for spreadsheet data | cjaye | Excel Programming | 11 | 05-08-2012 04:22 PM |
Extracting Contacts Data from Excel | Caesar | Outlook | 1 | 05-08-2011 05:54 AM |
extracting data from Table to text file | Anirudh_Dsp | Word Tables | 1 | 05-23-2010 07:48 AM |
Linked graphs printing wrong color | StaffsLebowski | Word | 0 | 12-15-2009 08:44 AM |