
When you have more than one value on the X axis of a PivotChart, drilling down allows you to zoom in to or out of the data one level at a time.
Use Drill Down Buttons
- With the PivotChart selected, click the Analyze button.
- Expand the Show/Hide group.
- Click the Field Buttons list arrow.
- Select Show Expand/Collapse Entire Field Buttons.
The Drill Down buttons now appear at the bottom-right corner of the PivotChart.
Even if the option is enabled, the Drill Down buttons will not appear on the PivotChart unless there is more than one value on the X axis.
- Click the Collapse Entire Field (+) button to collapse the lowest level of data.
The lowest level of data in the PivotChart is collapsed. Think of it as zooming out on the data.
- Click the Expand Entire Field (+) button to expand the next level of data.
Drill Down into Specific Chart Data
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.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- Create a Pivot Chart
- Refresh a Pivot Chart
- Pivot Chart Styles