Why? We will see that in the next article.Excel® 2013 For Dummies® Published by John Wiley & Sons, Inc.

Most of you will think – I will use the right type of visualization depending upon the data I am analyzing. How to use this feature? The obvious answer is NOT right. Sparklines are useful even if the data is not in one scale – as shown below. These help us look at the patterns by row or by column.

Pivot Tables are available only if the data is suitable – like a simple table.įinally, we have Sparklines – which are mini-charts.

Similar thing works with Pivot Tables as well. Try changing the type of data and notice that the recommended charts differ. This is brilliant – it shows different charts – which are optimized for this particular data. Greater than (is actually greater than the average). Just mouse movement gives you different types of visualizations. Say with formatting and move the mouse cursor over each option – Data Bars – Color Scales and so on. Let us work on some simple base data to work with… This humble button is helping you do exactly that – Data Visualization. Data visualization is one of these hot fields. Many of you must have heard about the importance data analytics is gaining in the IT field. Depressing but true.īut have the courage to click on this one – and see how brilliant this button is. We don’t know why they appear – so we have learnt to ignore them. Why? Because for many years we are seeing these random icons popping up all over the place. Here is the bigger version so that you can notice and recognize it next time! Select any data and look at what happens at the bottom right corner.

How to use this feature? The obvious answer is NOT right.

Excel 2013 quick analysis button