Show Value as Popup. Choose Show Value As > % of Grand Total. In some versions of Excel, it might show as % of Total. This is fine. Newer versions of Excel, like Excel 2016, Excel 2019 or Microsoft 365, show a % of Grand Total when you right-click on any numeric value. This is the key way to create a percentage table in Excel Pivots. Here you can build a pivot table first before copying it to the “Dashboard” worksheet. 1. Try it out by inserting a pivot table from the Insert Tab. 2. For the source data, enter the name of the data table which in this case would be “Sales_Table”. 3. Then select any cell in the “Tables” worksheet and click OK. The Select Data Source dialog now looks like this, with the Chart Data Range box displaying the range containing all of the pivot table data. Don’t click in this box, and don’t click Switch Row/Column, or your chart will become a pivot chart. Click OK, and notice how the chart now plots the pivot table data. Add the slicer field to the Filters area of the new pivot table. Move the slicer on top of the cell that contains the filter drop-down button in the Filters area of the new pivot table. Adjust the column width so the filter button is just to the right of the slicer. Turn off the Autofit column widths option on the new pivot 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 […] With pivot tables, you can compare and contrast different data sets, analyze trends over time, and identify outliers and unusual patterns. Additionally, using pivot charts and slicers can help you present your data more clearly and make it more accessible to others. Creating Customized Financial Models in Excel for Investment Banking. As an 1 Launch the Microsoft Excel application. 2 Browse to, and open, the file containing the pivot table and source data from which you want to create a chart. 3 Decide on the statement you want your pivot chart to represent. This decision will determine how you craft your pivot chart. nwBqqrt.