How Do You Use The Pivot Table And Chart Option In Excel?
If you have ever wondered how to use the pivot tables and charts options, use these steps to learn how. Open Microsoft Excel. To create a pivot table, open your data list worksheet. This contains the data you need to summarize in a pivot table. Position the cell cursor somewhere in the cells of the worksheet. Select “Insert” from the Ribbon at the top of the worksheet. Once the Create Pivot Table dialog box appears, indicate the location of your data source and pivot table. Click “OK.” The program will add a placeholder graphic it the text, “To build a report, choose fields from the Pivot Table Field List,” where the new pivot table will be located. Assign fields in Pivot Table Field List by dragging a field name from the Choose Fields To Add To Report List to one of the four areas (Report Filter, Column Labels, Row Labels, Values) in the Drag Fields Between Areas Below section, which is at the bottom of the task pane. To change font, font size or alignment of table, select “Home” on t
