Subscribe Bookmark RSS Feed



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.






 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






Very helpful!

Article Labels
Article Tags