Subscribe Bookmark RSS Feed
julian

Staff

Joined:

Jun 25, 2014

"Percent of Total" Formula Column Utility

This Add-in generates formula columns calculating the percent of total (row-wise) for the selected numeric columns. These columns are especially useful when creating stacked bar or column chart of the columns of interest and you wish for your scale to be percent of total rather than a sum.  

 

Usage: After installing this Add-in, select the set of columns in the data table, then choose "Percent of Total Formula Columns" from the Add-ins menu. 

 

Note: The formulas generated by this Add-in will tolerate missing values row-wise for all but one of the selected columns.

 

 PctOfTotal.gif

 

 

 

 When creating a stacked bar or column chart, the resulting plot is of the composition, rather than the total:

 

Total SalesTotal Sales

 

 

Composition of SalesComposition of Sales

 

 

 

 

Article Labels
Article Tags
Contributors