Đang chuẩn bị liên kết để tải về tài liệu:
beginning microsoft excel 2010 phần 9

Hình 8-70. Salesepesons xuất hiện trong truyền thuyết huyền thoại biểu đồ liệt kê các nhân viên bán hàng, mỗi một trong một loạt dữ liệu và kết quả là các nút bán hàng sẽ xuất hiện trong lĩnh vực Legend (Series). (Nếu bạn không thể nhìn thấy tất cả các văn bản trong khu vực nút này, | CHAPTER 8 PIVOTTABLES AND PIVOT CHARTS Figure 8-70. Here the Salesepesons appear in the legend Here the chart legend lists the salespersons each one now a data series and as a result the Salesperson button will appear in Legend Fields Series . If you can t see all the text in this button area you can click on and drag the left edge of the PivotTable Field List pane. Now for the second pivot chart approach. Here you initiate the process by clicking anywhere in the source data and then Insert tab the PivotTable down arrow Pivot Chart OK we re accepting the defaults in the dialog box here . You ll see Figure 8-71 Figure 8-71. Another way to start charting Note the PivotTable8 legend in the PivotTable grid in the upper left of screen shot merely refers to the number of PivotTables I ve constructed on the workbook . 306 CHAPTER 8 PIVOTTABLES AND PIVOT CHARTS Once this tableau is ushered onto the screen you can click on or drag the fields in the PivotTable Field List into the appropriate button areas just as if you were constructing a pivot report. Just remember however that here Row Labels is called Axis Fields Categories and the Columns Labels area reverts to Legend Fields Series . By simply clicking the checkboxes by Salesperson and Order Amount I ll produce precisely the same chart you see in Figure 8-70 . And if you want to delete a pivot report click anywhere in the report and click PivotTable Tools Options tab the Select down arrow in the Actions button group Entire PivotTable. Then press the Delete key. To delete a pivot chart just select it you can select it when you see the four-side arrow over the chart and press Delete. Interestingly enough if you delete a pivot report that has been used as the source of a pivot chart deleting the report leaves the chart onscreen even though it s no longer connected with any data. However if you click Options Actions Clear Clear All you ll delete both the PivotTable and its associated chart. In Conclusion. Once you get the .