![]() ![]() 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 |