Excel graph source data
 

I have a graph in excel, but I no longer have the source data from which the
graph was created. Is it possible to recover the original source data
directly from the graph? How do I do this? Thanks in advance.

Search the google.com archives of the XL newsgroups. Someone, I
believe Harlan Grove, posted leads to program(s) that let one convert
charts in a picture into data in a worksheet. However, I have no clue
what one would look for. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a graph in excel, but I no longer have the source data from which the
graph was created. Is it possible to recover the original source data
directly from the graph? How do I do this? Thanks in advance.

Hi,
Since the graph is maintaining its integrity without having the source data,
it is likely that the graph has been delinked from the original data it was
created from. If that is the case, when you click on the line line/curve in
the Excel spreadsheet, the formula bar should show the x- and y- arrays with
the individual values separated by commas. Copy and paste each array to a
cell; select one of those cells, go to Data -Text to Columns-Next, select
'Comma' under delimiters, and click Finish.
If there are far too many data points involved, Excel may complain 'Formula
is too long'; I don't know of any direct method of retrieving the data in
such a scenario. An indirect approach would be to digitize a hardcopy (or
scanned file) of the graph with a digitizing program; there is a program
called 'Unscanit' (if I remember right) that would be able to handle such a
task.
Regards,
B.R.Ramachandran


"RRRBBB" wrote:

I have a graph in excel, but I no longer have the source data from which the
graph was created. Is it possible to recover the original source data
directly from the graph? How do I do this? Thanks in advance.

Hi,
This is a continuation of my earlier response to your posting. Information
about UnScanIt (the digitizing software I was talking about) may be found at
www.silkscientific.com. I haven't used that software, but I gather that you
scan a hardcopy of a graph and UnScanIt returns a digitized output of the x-
and y- data.
Regards,
B.R.Ramachandran

"RRRBBB" wrote:

I have a graph in excel, but I no longer have the source data from which the
graph was created. Is it possible to recover the original source data
directly from the graph? How do I do this? Thanks in advance.

If the chart is still a functioning chart, you can use a macro similar
to the one in this page from the Microsoft Knowledge Base:

http://support.microsoft.com/default...;EN-US;Q300643

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


RRRBBB wrote:

I have a graph in excel, but I no longer have the source data from which the
graph was created. Is it possible to recover the original source data
directly from the graph? How do I do this? Thanks in advance.