Microsoft Office Tutorials and References
In Depth Information
Creating dynamic charts by using PivotCharts
On the Design tool tab, in the Type group, click Change Chart Type to open the
Change Chart Type dialog box.
Click Line , click the first Line chart subtype, and then click OK to change your
PivotChart to a line chart.
In the PivotTable Fields pane, in the Choose fields to add to report area, point
to the Center field header. Click the filter arrow that appears and then, in the filter
menu, clear the Select All check box to remove the check boxes from the filter list
Select the Northeast check box, and then click OK to filter the PivotChart.
CLEAN UP Close the RevenueAnalysis workbook, saving your changes if you want to.