Often times, there will be a set of data in your PivotChart for which you’ll want to see more detailed information. For example, if the month of March had unusually high sales figures, you may want to see which team members helped contribute to the success. You can drill into a specific area of the chart to see what spreadsheet data contributes to that data point.
Select any series in the chart area.
Select the specific data set you want to drill down on.
Right-click the data set.
Select Show Detail in the menu.
All the data that makes up that specific data set is revealed on a separate worksheet. If, after you’ve reviewed the data, you no longer need this information, the sheet can be deleted.