FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A pivot chart will always have the same layout as the pivot table on which it is based. As a workaround, you can make a copy of the pivot table, and set it up the way you need to. Then, hide the original pivot table – the one that is connected to the pivot chart.

Detailed explanation-2: -Creating a Simple Pivot Chart Our pivot chart is always associated with a Pivot table report, hence, we will see a Pivot table report alongside the chart we created in our Excel worksheet.

Detailed explanation-3: -Click File Tab, and click “Options” item. Click the Customize Ribbon in the Excel Options window, and then, you will see Customize the Ribbon in the right pane. Choose Commands Not in the Ribbon by clicking the arrow, and then use the scroll bar to search for the PivotTable and PivotChart Wizard.

Detailed explanation-4: -The first takes advantage of Excel’s Recommended Charts tool. When you use this feature, you do not need to create a PivotTable first in order to create and use a PivotChart. You can also create a PivotChart from an already existing PivotTable, making use of the filters and fields you have already organized.