Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? Your PivotTable will now display the same two columns of data both numerically and as a percentage of total, as pictured ...

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Let’s move on and build a PivotTable to support the PivotChart (Figure A). How to build the PivotTable in Excel Thanks to the data structure, the PivotTable will be simple to build.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.