Add a PivotChart You can add a PivotChart to a report. To add a PivotChart, complete the following steps: Click the Options tab. In the Tools group, click PivotChart. Parent Topic: Procedures - Formatting Custom Reports in Excel