As mentioned, you can also create a custom pivot chart based on specific conditions. In the example below, we will create a pivot table to see how many units each salesperson sold in a given month ...

Now, we are going to make the second table, in which we will add data for the value, pointer. See photo above. Calculate the value and pointer by using the reference =360- (D5+D6). See photo above.

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.