Here are the solutions that I have read about so far and the problems with each: 1. Copy and paste the pivot chart: This does, as described, copy and paste the pivot chart into a new location, however you cannot then edit the pivot table and pivot the table. (It almost takes a picture of the table). In Using Pivot Table Data for a Chart with a Dual Category Axis, I showed how to make a Chart with a Dual Category Axis using a pivot table to properly arrange the source data. I generally prefer using a regular chart, because pivot charts are pretty inflexible when it comes to formatting. Unfortunately, a […] Click on Pivot Table (or use the keyboard shortcut – ALT + N + V) In the Create Pivot Table dialog box, make sure that the Table/Range is correct and New Worksheet in Selected. Check the box which says – “Add this data to the Data Model” Click OK. The above steps would insert a new sheet which has the new Pivot Table. We will open a new sheet and type the content that will form the main part of our table. Figure 1: Options for the Drop-down List or menu. We will select the range where we will insert only values present in the list. We will use A3:A11. We will click on the data tab. Figure 2: Click on Data Tab. We will click on Data Validation. Full Tutorial with voice over explanation: Click on the Columns button to add Experience with data visualization, as shown in Figure 2.33. Figure 2.33: In the Pivot table editor, click the Columns Add button and select Experience with data visualization . To go one step further, Filter the data to limit the pivot table results by another category. For example, in the drop-down menu, you To do this, just click the "Refresh" button in the pivot table toolbar. You also have the option to click "Refresh all" which updates all the pivot tables in the workbook. 5. Use slicers to filter your data . Slicers allow you to filter your pivot table data based on your selected criteria. pivot_table. Required. A reference to any cell, range of cells, or named range of cells in a PivotTable. This information is used to determine which PivotTable contains the data that you want to retrieve. field1, item1, field2, item2 Optional. 1 to 126 pairs of field names and item names that describe the data that you want to retrieve. JsBm.