3 Answers. Select a blank cell a few rows or columns away from the pivot table. Insert an XY Scatter chart, which will be blank, because no data was selected. Right click the chart, choose Edit Data. Add a new series, Edit this series, select the ranges with the series name, X Values, and Y Values. Click OK a couple times to return to Excel. To create a Pivot Chart in Excel, follow these steps: Select the range and go to the Insert tab. Choose the PivotChart & PivotTable option under the PivotChart group. Then, select the location to place the PivotChart. After inserting a Pivot Chart, choose fields from PivotChart Fields. Step-1: Copy the pivot table. The first step is to open the original Excel file containing the Pivot table. Then select the pivot table and “Right Click” on it. Click on the “Copy” option from the right-click menu. Alternatively, you can press the “Ctrl+C” keys on your keyboard to copy the pivot table. 1. Simplicity. An important advantage of a pivot table is that it is easy to use. You can easily summarize data by dragging the columns to different sections of the table. The columns can also be re-arranged with the click of a mouse. 2. Data Analysis. With the help of excel pivot tables, you can handle large quantities of data in a single go. Pivot charts are a powerful way to visualize and analyze data in Excel. They allow you to summarize and compare large amounts of data in different ways, such Images were taken using Excel 2013 on Windows 7. Click anywhere in your PivotTable and open the PivotTable Fields pane. In the Values area, select Value Field Settings from the field’s dropdown menu. In the Value Field Settings dialog box, select the Show Values As tab. The default is “No Calculation”. Click Calculated Field on the drop-down menu. It will open a new window where you can add a new, custom column to your pivot table. 6. Enter a name for your column in the "Name" field . Click the Name field, and type in the name you want to use for your new column. Select the Pivot table by dragging the mouse across the entire Pivot table or by selecting the cells holding the Shift key. Press Ctrl+X to cut the table from the initial position, go to the cell where you want to move the table, and press Ctrl+V to paste the table in the final location. Method 1 – Using Pivot Table Formatting Icon. This method uses the Pivot Table Formatting Options icon that appears as soon as you apply conditional formatting in a pivot table. Here are the steps to do this: Select the data on which you want to apply conditional formatting. Go to Home –> Conditional Formatting –> Top/Bottom Rules Step 5: Format the Chart. The Grand Total value is the top segment of the stacked column chart. We need to hide this, but first let’s select the grand total series and add Data Labels > Inside Base: Next, with the grand total series still selected go to the Format tab > Shape Fill > No Fill. Hide the gridlines and vertical axis, and place the qInu0.