Pivot Diagramm. To filter this pivot chart execute the following steps. Click any cell inside the pivot table.
To insert a pivot chart execute the following steps. Pivot chart insert pivot chart. This will open power pivot window.
Click any cell inside the pivot table.
Go to power pivot manage. Open the power pivot window. Now to add an average line or grand total line in a pivot chart in excel you can do as follows. To insert a pivot chart execute the following steps.
