If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

Insert data and create a pivot table (or several!) First, generate the raw data set that you plan to use to create an interactive dashboard in Excel.