Now, drag the Sales in the Values section.Then, click on the Sales options in the PivotTable Fields.Next, select the New worksheet to place the PivotTable.In the Table/Range section, select the range of cells B4 to D19.PivotTable from table or range dialog box will appear.From the Tables group, select PivotTable.Then, go to the Insert tab in the ribbon.First, we need to select the whole dataset.To make a frequency distribution table in Excel, you need to follow the steps carefully. We want to find out the frequency between a given amount. To show this, we take a dataset that includes some salesman’s name, product, and sales amount. We can use Pivot Table to make a frequency distribution table in Excel. Using Pivot Table to Make Frequency Distribution Table in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |