Tip: Other languages are Google-Translated. You can visit the English version of this link.
or

Register

or

## How to extract data from chart or graph in Excel?

In Excel, we usually use chart to show data and trend for more clearly viewing, but in sometimes, maybe the chart is a copy and you haven’t the original data of the chart as below screenshot shown. In this case, you may want to extract the data from this chart. Now this tutorial is talking about data extracting from a chart or graph.
Extract data from chart with VBA

#### Extract data from chart with VBA

###### Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!

1. You need to create a new worksheet and rename it as ChartData. See screenshot:

 with more than 120 handy Excel functions, enhance working efficiency and save working time.

2. Then select the chart you want to extract data from and press Alt + F11 keys simultaneously, and a Microsoft Visual Basic for Applications window pops.

3. Click Insert > Module, then paste below VBA code to the popping Module window.

VBA: Extract data from chart.

Sub GetChartValues()
'Updateby20150203
Dim xNum As Integer
Dim xSeries As Object
xCount = 2
xNum   = UBound(Application.ActiveChart.SeriesCollection(1).Values)
Application.Worksheets("ChartData").Cells(1, 1) = "X Values"
With Application.Worksheets("ChartData")
.Range(.Cells(2, 1), _
.Cells(xNum + 1, 1)) = _
Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
End With
For Each xSeries In Application.ActiveChart.SeriesCollection
Application.Worksheets("ChartData").Cells(1, xCount) = xSeries.Name
With Application.Worksheets("ChartData")
.Range(.Cells(2, xCount), _
.Cells(xNum + 1, xCount)) = _
Application.WorksheetFunction.Transpose(xSeries.Values)
End With
xCount = xCount + 1
Next
End Sub

4. Then click Run button to run the VBA. See screenshot:

Then you can see the data is extracted to ChartData sheet.

#### Export Range as Graphic

Kutools' Export Range as Graphic is aim to save or export a selection cells as multiple graphic formats.

Tip:

1. You can format the cells as you need.

2. The data of the selected chart is extracted to the first cell of the ChartData sheet in default.

 If you are interested in this addi-in,

### Recommended Productivity Tools

#### Office Tab

Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

#### Kutools for Excel

Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

300 New Features for Excel, Make Excel Much Easy and Powerful:

• Merge Cell/Rows/Columns without Losing Data.
• Combine and Consolidate Multiple Sheets and Workbooks.
• Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
• Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,

Say something here...
symbols left.
###### or post as a guest, but your post won't be published automatically.
• To post as a guest, your comment is unpublished.
· 1 years ago
This doesn't appear to work for a scatter plot as it only extracts one set of "x" data. How can I amend it to extract all "x" data sets?
• To post as a guest, your comment is unpublished.
· 1 years ago
• To post as a guest, your comment is unpublished.
· 1 years ago
i've tried with a scatter plot graph as well, but only get one line of valor.

i need so much to find a way to extract data from scatterplot graphs.
• To post as a guest, your comment is unpublished.
· 1 years ago
I failed to get the prices of a fund chart on my mac excel 2011 . Run time error '91' object variable or block variable not set . Don't know how to debug . Appreciate any help .
• To post as a guest, your comment is unpublished.
· 1 years ago
Very useful and perfect
• To post as a guest, your comment is unpublished.
· 1 years ago
gives me values that i created chart with not all the values in range
• To post as a guest, your comment is unpublished.
· 2 years ago
Amazing command, thanks a lot!

I used it with a pivot chart and it works!