Excel Template for Presenting Denominators in Column Charts

Excel data tables can be hard to read when they contain more than a few data points. However, it is important to include the denominator when presenting time-series percentage or rate indicators . One alternative to the data table is to present two stacked charts: a line chart representing the percentage or rate indicator and a column chart representing the denominator, as seen below.

Denominator Column Chart
 
The attached excel file contains templates for the following charts:
  • One percentage indicator
  • Two percentage indicators
  • One percentage indicator compared to one rate indicator
     
Countries: 
Report Author(s): 
Simon Hiltebeitel
Organization(s): 
USAID Applying Science to Improve Systems (ASSIST) Project/URC
ASSIST publication: 
no
Facebook icon
Twitter icon
LinkedIn icon
e-mail icon