Using the steps below, we can add an average line in a pivot chart in Excel. 1. Include a column Average in our source data to show the average value. 2. Click on our pivot chart to enable the Analyze tab and choose the Refresh option. 3. Drag and drop the Average field in the Values section of the PivotChart Fields window. 4. Now click on any data point of the Average series in the pivot chart to select the specific data series. 5. Right-click the chosen data series and select the Change Series Chart Type option. 6. In the Change Chart Type window, choose the Combo option. And then, select the Average field chart type as Line and check its Secondary Axis box. 7. Once we click OK, the average line will appear in our pivot chart.