Can we create two PivotCharts in one excel sheet ?
Yes, we can create multiple PivotCharts in the same Excel sheet.
While creating the PivotChart:
-
Go to Insert → PivotChart.
-
Choose the data source.
-
In the option Choose where you want the PivotChart to be placed, select Existing Worksheet.
-
Specify the cell location (for example, A1, E20, etc.) where you want the chart to appear.
Repeat the same steps and select a different cell location to create the second PivotChart in the same sheet.
