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...
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...
Create Simple Dial Charts in Excel – How To
Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user's ability to comprehend the information and significantly cuts down the time to take decisions. That is...
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...
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...
ABC Inventory Analysis using Excel Charts
Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had loads of fun as we not only understood how to...