| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating data from a chart
Great. thank you!
"Andy Pope" wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Sarah0824" wrote in message ... If someone emails me a chart, but does not include the source data, is there anyway to generate that data from the chart? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error when creating a stock chart from data in .CSV file | Excel Discussion (Misc queries) | |||
| Creating a chart using data from multiple worksheets | Charts and Charting in Excel | |||
| Creating a chart of text data | Excel Discussion (Misc queries) | |||
| Creating data for a chart | Charts and Charting in Excel | |||
| Creating Chart from Two Rows of Data | Excel Discussion (Misc queries) | |||
Hybrid Mode
