Microsoft Office Tutorials and References
In Depth Information
14. Select the PivotChart and then, on the Analyze contextual tab, in the Data group,
click Refresh .
Excel adds the new table data to your PivotChart.
15. On the Design contextual tab, in the Type group, click Change Chart Type .
The Change Chart Type dialog box opens.
16. Click Line , and then click the first Line chart subtype.
17. Click OK .
Excel changes your PivotChart to a line chart.
18. In the PivotTable Field List task pane, in the Choose fields to add to report
area, point to the Center field header.
Search JabSto ::

Custom Search