To move the pivot chart back to the worksheet, just reverse the process.If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Create a Pivot Table Once you’ve created a pivot chart, you can easily move it into its own worksheet. After you select a style and click OK, you’ll see a pivot chart added to the same worksheet as the pivot table. Then, navigate to the Options tab of the PivotTable Tools ribbon, and click PivotChart. When you want to create a pivot chart from an existing pivot table, first select any cell in the pivot table. Now let’s delete this worksheet and look at how to create a pivot chart from an existing pivot table. If we select the pivot chart and move Region from the Axis field area to the Legend field area, both the pivot chart and the pivot table are reconfigured. If we select the pivot table and move Region back to the Row Labels area, we reverse the change.
As you can see, any change we make to the pivot chart is reflected in the pivot table. Let’s select the chart and add Total Sales and Region. Note that the names in the pivot list pane are slightly different when the chart is selected - Row Labels are called Axis fields, and Column labels are referred to as Legend Fields. As with a regular pivot table, the field list pane appears and disappears when we select the pivot table and the pivot chart. The result is a new blank pivot table and pivot chart, both on the same worksheet. Note the title of the window - Create Pivot Table with Pivot Chart. Similar to creating a pivot table, you’ll need to confirm the data source and the location. Then go to the Insert tab and click the Pivot Table menu. If you’re creating a pivot chart from scratch, first select a cell in the source data. All pivot charts are based on pivot tables, so in order to have a pivot chart you must also have a pivot table.
0 kommentar(er)
