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.

In this case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.