Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2008

Tip: Looking for answers? Try searching our database.

Creating data from a chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sarah0824 - 13 May 2008 04:16 GMT
If someone emails me a chart, but does not include the source data, is there
anyway to generate that data from the chart?
Andy Pope - 13 May 2008 09:40 GMT
Hi,

Assuming you have a chart and not an image of a chart you could either
Select a series and go to the formula bar and press F9.

In a very simple test example the following formula converted to,

=SERIES(,[Book3]Sheet1!$A$2:$A$5,[Book3]Sheet1!$B$2:$B$5,1)

=SERIES(,{"a","b","c","d"},{1,2,3,4},1)

or you could try using code.

Sub GetChartData()
' output labels and values to sheet
   Dim vntData As Variant
   Dim vntLabels As Variant
   Dim lngIndex As Long

   With ActiveChart
       With .SeriesCollection(1)
           vntData = .Values
           vntLabels = .XValues
           For lngIndex = LBound(vntData) To UBound(vntData)
               ActiveSheet.Cells(lngIndex, 1) = vntLabels(lngIndex)
               ActiveSheet.Cells(lngIndex, 2) = vntData(lngIndex)
           Next
       End With
   End With

End Sub

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> If someone emails me a chart, but does not include the source data, is
> there
> anyway to generate that data from the chart?
Brad - 13 May 2008 15:51 GMT
In the event someone is trying to extract data from a chart "picture" where
there are no linked data, there is a neat little Excel-based utility where
one inputs known x and y axes limits and a few other inputs, then it
approximates the values found in the graph.

Andy and others, no doubt, could program such things. This one is someone's
commercial effort...

Google for... Grab It! Graph Digitizer.

Cheers!  Brad

> Hi,
>
[quoted text clipped - 34 lines]
>> there
>> anyway to generate that data from the chart?
Sarah0824 - 14 May 2008 03:52 GMT
Great.  thank you!

> Hi,
>
[quoted text clipped - 34 lines]
> > there
> > anyway to generate that data from the chart?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.