How to add a single vertical bar to a Microsoft Excel line chart Your email has been ... Click anywhere inside the data set, which is a Table object named Sales in this case.

The easiest way to do this is to use Excel tables, which let you add rows that will be included with your pivot table whenever you hit refresh. But at the very least, you want your data to be in ...

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.

Next, you’ll add calculations to your table. This lets you summarize ... four rows in the table. Note: Excel will typically give the new column a name in line with the other headers (in this ...