Modify the PivotChart
Earlier we created a PivotChart with tblProducts. Let's do the same steps here, format the Chart then work with the PowerPivot options.
Try it: Edit the PivotChart Fields
Go to the PivotChart Fields.
Drag a Field to the Axis (Category): Type.
Drag a Field to the Value: Item.
And Try This: Format the PivotChart
Click on the PivotChart to select it.
The Chart Elements and Charts Styles should be available to the right of the Chart.
Go to Chart Styles->
Style.
Select a Style: Style 4.
And Try This: Rename the Sheet Tab
Double-click the sheet Tab.
Type a name: PivotChart2.
That will do.
