In the PivotTable Fields pane, select the Column fields applicable to the pivot table you can drag and drop, i.e., salesperson to the Rows section, Region to the Columns section, and sales to the Values section. PivotChart Fields task pane appears on the left side, which contains various fields, i.e., Filters, Axis (Categories), Legend (Series), and Values.Once you click OK, It inserts both PivotChart PivotTable in a new worksheet. By default, it selects table range, and it will ask you where to place a pivot table chart, here you need to always select in a new worksheet. It will ask for the options, i.e., from a table range or from an external database. Create PivotChart dialog box appears, which is similar to the Create Pivot Table dialog box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |