To shrink the wax remnant from the sides of the glass initially, you can also put the candle in the freezer for a few hours.
Example 2: Group a Pivot Table by Range. Imagine you have created the pivot table on the leftshown above, which groups 150 children according to age. The ages range from 5 to 16 years. If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows: 1  Right click on left column of the pivot table (containing the ages) and select the option Group...; 2  You will be presented with the 'Grouping' dialog box for numbers;
Follow these steps to create a pivot chart based on an existing pivot table in a worksheet: Create the pivot table and then click any cell in the pivot table on which you want to base the chart. Click the PivotChart button in the Tools group of the PivotTable Tools Options tab. The Insert Chart dialog box appears.You have many design choices for your pivot chart. Click the thumbnail of the type of chart you want to create. Click OK.ove a pivot chart to its own sheet. You may find it easier to customize and work with a pivot chart if you move the chart to its own chart sheet in the workbook. To do so, click the Move Chart button on the PivotChart Tools Design tab, click the New Sheet button in the Move Chart dialog box, and then click OK.