I am taking a slight detour in this post because I have been studying like mad for the Excel Expert exam. In the process, I have been reminded of a cool feature that was added in Excel 2013. If you are using Excel 2013 or 2016, try out the Recommended Chart feature.
In this era of data visualization, finding new ways to show your data is a great way to keep your presentations and reports interesting. But how do you figure out which type of chart(s) would work (other than your tried-and-true choice)? This is where the Recommended Chart feature shines. Once you have selected your data, choose Insert> Recommended Chart.
From here, you will see several choices that suit your particular data set: