Modify a PivotChart Report : PivotChart « PivotTable PivotChart « Microsoft Office Excel 2007 Tutorial






Click the PivotChart. 
           To filter fields, click the Axis Fields (Categories) or Legends Fields (Series), 
           and then select the filter options.
Click the PivotChart. To filter fields, click the Axis Fields (Categories) or Legends Fields (Series), and then select the filter options.
Click the Analyze tab. 
           Select a field, and then click the Expand Entire Field or Collapse Entire Field button.
Select a field, and then click the Expand Entire Field or Collapse Entire Field button.
Use Design to change chart styles, layouts, and type.
Use Design to change chart styles, layouts, and type.
Use Layout to change chart labels, axes, and background.
Use Layout to change chart labels, axes, and background.
Use Format to format chart elements using Shape and WordArt styles.
Use Format to format chart elements using Shape and WordArt styles.








9.1.PivotChart
9.1.1.Create a PivotChart Report from a PivotTable ReportCreate a PivotChart Report from a PivotTable Report
9.1.2.Delete a PivotChartDelete a PivotChart
9.1.3.Rename a PivotChartRename a PivotChart
9.1.4.Rename a field in a PivotChartRename a field in a PivotChart
9.1.5.Modify a PivotChart ReportModify a PivotChart Report
9.1.6.Refresh PivotChartRefresh PivotChart