![]() One thing that has helped me with transitioning from Excel 2003 is that Pivot Table Options> Display now has a "Classic PivotTable layout" choice which might make this a little easier to maneuver if you set it before you start.Ī great source for Pivot Table info is Debra Dalgleish's site. Your pivot chart should now be charting the new field too. Right-click in that same cell, the one that now says "Other," and choose "Expand/Collapse" and then "Collapse Entire Field." This hides the original Part Number field.Click into the cell with that label and, in the formula bar, type "Other." That changes the name of the new item. In this new field there will be an item called "Group1". ![]() This article explains how to make a pie chart in Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010. After adding a pie chart, you can add a chart title, add data labels, and change colors. You'll now have a new field called "Part Number2" in your field list and to the left (if it's a row field) of the Part Number field. Select the data and go to Insert > Insert Pie Chart > select chart type.Select the items that you want to group into your "Other" category.In your pivot table you'll need to sort the items in Part Number so that those with the smallest values are together.I'm imagining a Pivot Table with a field called "Part Number." ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |