Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

In this tutorial, I’ll show you how to reduce a column of slicer buttons to a vertical row of buttons. ... If the PivotChart Fields list doesn’t open, click the empty frame.

This file demonstrates the techniques explained in the article Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects.