![add horizontal line in excel pivot chart add horizontal line in excel pivot chart](https://cdn.extendoffice.com/images/stories/doc-excel/pivotchart-average-line/doc-pivotchart-average-line-008.png)
![add horizontal line in excel pivot chart add horizontal line in excel pivot chart](https://atlanticcapitalbank.com/wp-content/uploads/2020/10/Capture.png)
![add horizontal line in excel pivot chart add horizontal line in excel pivot chart](https://i.stack.imgur.com/M8Zes.png)
If you want to create a PivotChart only, then select PivotChart from the drop-down or if you want to create both a PivotChart and PivotTable, then select PivotChart PivotTable from the drop-down.
If you want to create a PivotChart only, then select PivotChart from the drop-down or if you want to create both a PivotChart and PivotTable, then select PivotChart PivotTable from the drop-down.