


Mark New Worksheet as the Choose where you want the PivotChart to be placed option. Step 2: The Create Pivot Chart window appears. Step 1:First highlight the range then go to the Insert tab > Click on PivotChart (in the Charts section). Also, meddling with an Excel PivotChart is not that complicated. In case, users don’t have an existing Excel Chart, they can insert one. Method 1: Applying Pivot Chart to Group Dates in Excel Follow the latter section to organize the Chart in a way that group dates in Excel Chats. In both cases, users need to understand the data types and thus respective Chart options. In reality, we may have an Excel Chart, to begin with, or have data to create a random Excel Chart. 3 Easy Ways to Group Dates in Excel Chart
