March 17, 2020
I'm trying to find a way to export datasheet from a chart.
Just to be clearer, I created a dashboard made up of many dynamic charts, slicers and pivot tables. Such dynamic charts update automatically depending on the selection made in the slicers. The sheets showing the data are not included in the charts (there are only the graphs).
Moreover, the dashboard data source is not visible to users.
Is it possible to download or export the data from a graph into another Excel sheet for further analysis (without creating a VBA) ?
July 16, 2010
The short answer is no. The chart only reads the data you give it, it cannot then export data itself. However, since the chart is referencing data, you can double click the grand total cell of the chart's source PivotTable and Excel will generate a new sheet containing the transactions that make up the dataset plotted in the chart.
Hope that helps.