Once you have a final version of your chart, use the automatic pivot table-generator to create a pivot table based on the layout of your chart.
Note:
The Pivot this Chart feature is not available for scatter and bubble chart types.
To create a pivot table based on your chart, in the Chart section, select Insert , then Pivot This Chart.
To create a pivot table based on your chart, in the Chart section, select