(Posted by Patrick Lee on 10 August 2017 at a different location, but migrated here on 05 Feb 2018).
You may not know that Excel 2016 added some useful new charts for analysing data. I particularly like the Treemap, Box & Whisker and Pareto charts. (The images below are taken from this Microsoft post, please see that link for more detail on these and other charts).
The Treemap gives you a quick view of which categories are most significant:
Read More “Useful charts for business/data analysis in Excel 2016”