Excel 2013’s trying to make your life a little easier with the Quick Analysis tool in Excel Video 375. The Quick Analysis tools uses built-in algorithms to look at your data and give you some ideas about how you might analyze it. Today we’ll look at the Charts section of the Quick Analysis button.
Notice how I get different recommended charts when I hover over different data. Also notice how much easier it is to understand those charts if I include the row and column headings when I select data for Excel to analyze. You’ll also see how to get more than the standard 4-5 recommended charts if you don’t like Excel’s initial recommendations. The next time you have some data you’d like to display, let Excel 2013’s Quick Analysis tool give you some good ideas to get started.
