Question: how to export data from excel chart?
Answer: Select the chart, and click a series to find the sheet name to which the chart is linked in the damaged or missing workbook. ... 
Double-click the tab of the new sheet called ChartData.
Type the original sheet name from step 1 over the highlighted "ChartData" and press ENTER.