
How to quickly visualize the distribution of your data using Ms Excel charts
The data for this demonstration comes from the PEPFAR Impact website, it was simplified to show you how you can, easily, visualize the distribution of any data using the box and whiskers plot chart, from Ms Excel In this specific case, I would like to know how the distribution of the performance of the reported indicator “ANC Clients who know HIV Status”, across time (2005-2016). 1. Make sure that your data is on a flat file format. 2. Insert chart a. Select the table conten