· 

Create a PivotChart & PivotTable simultaneously

Create a PivotChart and a PivotTable with one selection. You get to see your PivotTable being created and a PivotChart taking shape at the same time.

From the Insert tab, click the PivotChart drop-down option to select to create either a PivotChart or a PivotChart & PivotTable.

 

 

Write a comment

Comments: 0