![]() The data of the selected chart is extracted to the first cell of the ChartData sheet in default. Then you can see the data is extracted to ChartData sheet.Ģ. XNum = UBound((1).Values)Īpplication.Worksheets("ChartData").Cells(1, 1) = "X Values"Īpplication.Transpose(ActiveChart.SeriesCollection(1).XValues)įor Each xSeries In Īpplication.Worksheets("ChartData").Cells(1, xCount) = xSeries.NameĪ(xSeries.Values)Ĥ. ![]() Click Insert > Module, then paste below VBA code to the popping Module window. 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.ģ. You need to create a new worksheet and rename it as ChartData. Now this tutorial is talking about data extracting from a chart or graph.ġ. In this case, you may want to extract the data from this chart. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |