If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line Graph Data Recognition | Nat | Charts and Charting | 2 | April 30th, 2005 02:07 PM |
Mail merge problem when filtering data from Excel data source | Dave F | General Discussions | 5 | December 3rd, 2004 06:45 PM |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
Open Excel Workbook as Data Source | Debbie S. | Mailmerge | 1 | June 4th, 2004 11:00 AM |
Source Data Ranges in Charts | Tushar Mehta | Charts and Charting | 0 | November 30th, 2003 03:29 PM |