1. Click any cell inside the PivotTable. 2. Click the Analyze tab on the ribbon. 3. Click the Insert Timeline button. You can also insert a Timeline for PivotCharts and cube functions. The Insert Timelines dialog box appears. It automatically detects the date fields used in the PivotTable and has them available for you to select from. Many times, there will only be one available field.
確定! 回上一頁