Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2013, 08:20 AM
Abol Abol is offline Extracting data from ppt graphs without linked spreadsheet Windows 8 Extracting data from ppt graphs without linked spreadsheet Office 2010 64bit
Novice
Extracting data from ppt graphs without linked spreadsheet
 
Join Date: Jun 2013
Posts: 1
Abol is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-27-2013, 03:58 AM
JohnWilson JohnWilson is offline Extracting data from ppt graphs without linked spreadsheet Windows 7 64bit Extracting data from ppt graphs without linked spreadsheet Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Pretty sure if the linked Excel file has gone you are just left with a screen image of the original (No Data)
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 06-27-2013, 07:42 AM
Cosmo Cosmo is offline Extracting data from ppt graphs without linked spreadsheet Windows Vista Extracting data from ppt graphs without linked spreadsheet Office 2007
Competent Performer
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

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.
Reply With Quote
Reply

Tags
graphs, linked data, unlink



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting data from ppt graphs without linked spreadsheet Doing a linked paste within a linked spreadsheet tkondaks Word 1 08-17-2012 12:23 AM
Extracting data from ppt graphs without linked spreadsheet 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 ppt graphs without linked spreadsheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft