Making Sales Dashboard using Excel Slicers – How To

So many reasons why not to hate Excel dashboards. They are beautiful, they are dynamic, they make everything super easy to understand. And not to mention it one cool way to grab attention at...

Excel Actual Vs Target – Multi type charts with Subcategory axis and Broken line...

Last time when we learnt about multi-category axis we saw how meaningful chart can become. But today we are going to add in more flavours and ingredients to it and by the end of this...

Budget vs Actual Variance Reports with “In the Cell Charts” in Excel

In life we all want to be in control. And usually we measure or judge whether things under control by comparing whats happening with what should be happening. In other words, we tend compare the actual events/results with...

Moving X-axis labels at the bottom of the chart below negative values in Excel

By default if you insert a bar chart or line chart, the x-axis labels are stuck at 0 position of the axis. This usual behaviour gets in the way especially if you have negative values...

Making BCG Matrix in Excel – How To

BCG matrix is a strategic decision making technique that helps in resource allocation among different cost centers or cost objects by categorizing or ranking them based on their ability to generate cash inflows against...

Dynamically Highlight data points in Excel charts using Form Controls

Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible. But in some cases wrong chart types in...

Creating Timelines in Excel [How To]

Just recently I upgraded the office suit to 2013. And the first thing I did is to see how Excel looks. Its even better. Sublime, simple, to the point and just like the way...

Creating Excel charts with Subcategory axis – [Quick Tip]

This is definitely a neat trick. Usually we have single X-axis chart element. But you can have multi-category axis to show the information in a much more arranged manner. Following is what we are after....

Excel chart of Top / Bottom “N” values using RANK() function and Form controls

Ever fancied that you have large set of data and from it you can have a chart of top or bottom N values and better yet you have the ability to switch between chart...

Custom Data Labels with Colors and Symbols in Excel Charts – [How To]

Is it possible to have colored data labels like red for negatives and blue or green for positive values inside excel chart? This question was asked by some when I posted Variance Analysis in Excel – Making better...
12,950FansLike
2,155FollowersFollow
738SubscribersSubscribe