Excel graph source data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top